package com.ugoodtech.mdcc.core.utils;


import com.ugoodtech.mdcc.core.domain.KpiPaintReportVO.OperationalVO;
import com.ugoodtech.mdcc.core.domain.KpiPaintReportVO.ServiceResponseVo;
import com.ugoodtech.mdcc.core.domain.VstarCustomerSatisfactionReport.CustomerStatVo;
import com.ugoodtech.mdcc.core.domain.VstarCustomerSatisfactionReport.VstarCustomerSatisfactionReport;
import com.ugoodtech.mdcc.core.domain.VstarServiceReport.VstarServiceReport_CompleteFollowUp;
import com.ugoodtech.mdcc.core.domain.VstarServiceReport.VstarServiceReport_ServiceType;
import com.ugoodtech.mdcc.core.domain.VstarUserKpiReport.VstarUserKpiReport;
import com.ugoodtech.mdcc.core.domain.VstarUserKpiReport.VstarUserKpiReport_Complete;
import com.ugoodtech.mdcc.core.domain.VstarUserKpiReport.VstarUserKpiReport_NeedFollowUp;
import com.ugoodtech.mdcc.core.domain.VstarUserKpiReport.VstarUserKpiReport_Plan;
import com.ugoodtech.mdcc.core.dto.StationResponse;
import org.apache.commons.lang.StringUtils;
import org.apache.poi.util.Units;
import org.apache.poi.xwpf.usermodel.*;
import org.openxmlformats.schemas.wordprocessingml.x2006.main.*;

import java.io.*;
import java.math.BigInteger;
import java.net.HttpURLConnection;
import java.net.URL;
import java.text.DecimalFormat;
import java.util.ArrayList;
import java.util.List;

/**
 * Created by Administrator on 2018/6/5 0005.
 */
public class ExportWordUtil {
    public static void exportSTToWord(String titleName, String[][] list, String filePath) throws IOException {
        FileInputStream fileInputStream = new FileInputStream(filePath);
        XWPFDocument document = new XWPFDocument(fileInputStream);

//        //创建document对象
//        XWPFDocument document = new XWPFDocument();
        XWPFParagraph par = document.createParagraph();
        FileInputStream streamHappy = new FileInputStream("E:\\ugood\\project\\vstar\\vstar_backend\\web\\src\\main\\webapp\\templet\\happy.png");
        FileInputStream streamAlert = new FileInputStream("E:\\ugood\\project\\vstar\\vstar_backend\\web\\src\\main\\webapp\\templet\\alert.png");
//        document.addPicture(picInputStream,XWPFDocument.PICTURE_TYPE_PNG);
        //创建表格
        int row = 4;
        int column = 3;
        XWPFTable table = document.createTable(row, column);


        CTTblBorders borders = table.getCTTbl().getTblPr().addNewTblBorders();

        CTBorder hBorder = borders.addNewInsideH();
        hBorder.setVal(STBorder.NIL);  // 线条类型
        hBorder.setSz(new BigInteger("1")); // 线条大小
        hBorder.setColor("3A5FCD"); // 设置颜色8
        setTableWidth(table, "10000");

        CTBorder vBorder = borders.addNewInsideV();
        vBorder.setVal(STBorder.NIL);
        vBorder.setSz(new BigInteger("1"));
        vBorder.setColor("3A5FCD");

        CTBorder lBorder = borders.addNewLeft();
        lBorder.setVal(STBorder.Enum.forString("single"));
        lBorder.setSz(new BigInteger("1"));
        lBorder.setColor("3A5FCD");

        CTBorder rBorder = borders.addNewRight();
        rBorder.setVal(STBorder.Enum.forString("single"));
        rBorder.setSz(new BigInteger("1"));
        rBorder.setColor("3A5FCD");

        CTBorder tBorder = borders.addNewTop();
        tBorder.setVal(STBorder.Enum.forString("single"));
        tBorder.setSz(new BigInteger("1"));
        tBorder.setColor("3A5FCD");

        CTBorder bBorder = borders.addNewBottom();
        bBorder.setVal(STBorder.Enum.forString("single"));
        bBorder.setSz(new BigInteger("1"));
        bBorder.setColor("3A5FCD");

        mergeCellsHorizontal(table, 2, 0, 2);
        mergeCellsHorizontal(table, 3, 0, 2);

        //处理表达合并和数据填充

//        //合并列
//        mergeCellsVertically(table, 0, 0, 1);
//        mergeCellsVertically(table, 2, 0, 1);
//        mergeCellsVertically(table, column-1, 0, 1);
//
//        //合并行
//        for(int i=0;i<row-2;i++){
//            mergeCellsHorizontal(table, i, 0, 1);
//            mergeCellsHorizontal(table, i, 2, 4);
//        }
//
//        mergeCellsHorizontal(table, 0, 5, column-2);
//        mergeCellsHorizontal(table, row-2, 0, 4);
//        mergeCellsHorizontal(table, row-1, 0, 4);
//        mergeCellsHorizontal(table, row-1, 5, column-1);


        //填充数据
        XWPFTableRow rowIndex = table.getRow(0);
        XWPFTableCell cell = rowIndex.getCell(0);
        setCellText(cell, 5000, false, 0, "000000");
//                cell.setText(a[0].toString());
        cell.setColor("5082bf");
        XWPFParagraph p1 = cell.getParagraphs().get(0);
        XWPFRun r1 = p1.createRun();
        r1.setText("通风是否足够？（单选）");
        r1.setColor("FFFFFF");
        r1.setBold(true);
        r1.setFontFamily("微软雅黑");

        XWPFTableCell cell10 = rowIndex.getCell(1);
        setCellText(cell10, 4500, false, 0, "000000");
//                cell.setText(a[0].toString());
        cell10.setColor("5082bf");
//                setCellText(cell10, a[2].toString(), 4000, true, 0, "FFFFFF");
        XWPFParagraph p10 = cell10.getParagraphs().get(0);
        XWPFRun r10 = p10.createRun();
        r10.setText("是");
        r10.setColor("FFFFFF");
        r10.setBold(true);


        XWPFTableCell cell1 = rowIndex.getCell(2);
        setCellText(cell1, 500, false, 0, "000000");
//                cell1.setText(a[5].toString());
        cell1.setColor("5082bf");
        XWPFParagraph pargraph = cell1.getParagraphs().get(0);
        XWPFRun run = pargraph.createRun();

        try {
            run.addPicture(streamHappy, CustomXWPFDocument.PICTURE_TYPE_PNG, "happy.png", Units.toEMU(20), Units.toEMU(20));
//                        int ind = document.addPicture(streamHappy,CustomXWPFDocument.PICTURE_TYPE_PNG);
//                        document.createPicture(ind, 50 , 50,pargraph);
        } catch (Exception e) {
            e.printStackTrace();
        }

        XWPFTableRow rowIndex1 = table.getRow(1);
        XWPFTableCell cell21 = rowIndex1.getCell(0);
        setCellText(cell21, 5000, false, 0, "000000");
//                cell21.setColor("5082bf");
        XWPFParagraph pargraph1 = cell21.getParagraphs().get(0);
        XWPFRun run1 = pargraph1.createRun();
//                FileInputStream streamPhoto = new FileInputStream("http://vstar.oss-cn-hangzhou.aliyuncs.com/" + a[6].toString());


        XWPFTableCell cell2 = rowIndex1.getCell(1);
        setCellText(cell2, 4500, false, 0, "000000");
        cell2.setText("太棒了! 通风足够可提升工作环境,让工人保持良好的工作状态。同时能够把钣金工作所产生的烟尘驱散");
        XWPFTableCell cell3 = rowIndex1.getCell(2);
        setCellText(cell3, 500, false, 0, "000000");
        cell3.setText("");

        XWPFTableRow rowIndex2 = table.getRow(2);
        XWPFTableCell cell4 = rowIndex2.getCell(0);
//                setCellText(cell4, 5000, false, 0, "000000");
        cell4.setColor("5082bf");
        XWPFParagraph p4 = cell4.getParagraphs().get(0);
        XWPFRun r4 = p4.createRun();
        r4.setText("建议");
        r4.setColor("FFFFFF");
        r4.setBold(true);
        XWPFTableCell cell5 = rowIndex2.getCell(1);
//                setCellText(cell5, 4500, false, 0, "000000");
        cell5.setText("");
        cell5.setColor("5082bf");
        XWPFTableCell cell50 = rowIndex2.getCell(2);
//                setCellText(cell50, 500, false, 0, "000000");
        cell50.setText("");
        cell50.setColor("5082bf");

        XWPFTableRow rowIndex3 = table.getRow(3);
        XWPFTableCell cell6 = rowIndex3.getCell(0);
//                setCellText(cell6, 5000, false, 0, "000000");
        cell6.setText("值得表扬! 继续保持良好的通风");
        XWPFTableCell cell7 = rowIndex3.getCell(1);
//                setCellText(cell7, 4500, false, 0, "000000");
        cell7.setText("");


//        //填充数据
//        XWPFTableRow rowIndex = table.getRow(0);
//        XWPFTableCell cell = rowIndex.getCell(0);
//        cell.setText("钣喷车间是否在");
//        setCellText(cell,2000, false, 0, "000000");
//        XWPFTableCell cell1 = rowIndex.getCell(1);
//        cell1.setText("                    ");
//        setCellText(cell1, 2000, false, 0, "000000");
//
//        XWPFTableRow rowIndex1 = table.getRow(2);
//        XWPFTableCell cell2 = rowIndex1.getCell(0);
//        cell2.setText("");
//        XWPFTableCell cell3 = rowIndex1.getCell(1);
//        cell3.setText("");
//
//        XWPFTableRow rowIndex2 = table.getRow(3);
//        XWPFTableCell cell4 = rowIndex2.getCell(0);
//        cell4.setText("建议");
//        XWPFTableCell cell5 = rowIndex2.getCell(1);
//        cell5.setText("");
//
//        XWPFTableRow rowIndex3 = table.getRow(4);
//        XWPFTableCell cell6 = rowIndex3.getCell(0);
//        cell6.setText("");
//        XWPFTableCell cell7 = rowIndex3.getCell(1);
//        cell7.setText("");

        //添加标题
        XWPFParagraph titleParagraph = document.createParagraph();
        //设置段落居中
        titleParagraph.setAlignment(ParagraphAlignment.CENTER);
        XWPFRun titleParagraphRun = titleParagraph.createRun();
        titleParagraphRun.setText("维修站产能状况");
//        titleParagraphRun.setColor("000000");
        titleParagraphRun.setFontSize(20);

        //添加标题
        XWPFParagraph titleParagraph1 = document.createParagraph();
        //设置段落居中
        titleParagraph1.setAlignment(ParagraphAlignment.LEFT);
        XWPFRun titleParagraphRun1 = titleParagraph1.createRun();
        titleParagraphRun1.setText("填写项");
//        titleParagraphRun.setColor("000000");
        titleParagraphRun1.setFontSize(17);
//        //创建表格
//        int row1 = 10;
//        int column1 = 4;
//        XWPFTable table1 = document.createTable(row1, column1);
//        setTableWidth(table1, "10000");
//        //填充数据
//        XWPFTableRow rowIndex10 = table1.getRow(0);
//        XWPFTableCell cell10 = rowIndex10.getCell(0);
//        setCellText(cell10, 5500, false, 0, "000000");
//        cell10.setText("项目");
//        XWPFTableCell cell11 = rowIndex10.getCell(1);
//        setCellText(cell11, 1500, false, 0, "000000");
//        cell11.setText("行业参考值（范围）");
//        XWPFTableCell cell12 = rowIndex10.getCell(2);
//        setCellText(cell12, 1500, false, 0, "000000");
//        cell12.setText("偏差诊断及建议");
//        XWPFTableCell cell13 = rowIndex10.getCell(3);
//        setCellText(cell13, 1500, false, 0, "000000");
//        cell13.setText("AkzoNobel解决方案");
//
//        XWPFTableRow rowIndex11 = table1.getRow(1);
//        XWPFTableCell cell20 = rowIndex11.getCell(0);
//        cell20.setText("月喷漆产值（元）");
//        XWPFTableCell cell21 = rowIndex11.getCell(1);
//        cell21.setText("");
//        XWPFTableCell cell22 = rowIndex11.getCell(2);
//        cell22.setText("");
//        XWPFTableCell cell23 = rowIndex11.getCell(3);
//        cell23.setText("");
//
//        XWPFTableRow rowIndex12 = table1.getRow(2);
//        XWPFTableCell cell30 = rowIndex12.getCell(0);
//        cell30.setText("喷漆维修台次");
//        XWPFTableCell cell31 = rowIndex12.getCell(1);
//        cell31.setText("");
//        XWPFTableCell cell32 = rowIndex12.getCell(2);
//        cell32.setText("");
//        XWPFTableCell cell33 = rowIndex12.getCell(3);
//        cell33.setText("");
//
//        XWPFTableRow rowIndex13 = table1.getRow(3);
//        XWPFTableCell cell40 = rowIndex13.getCell(0);
//        cell40.setText("车间喷漆工人数");
//        XWPFTableCell cell41 = rowIndex13.getCell(1);
//        cell41.setText("");
//        XWPFTableCell cell42 = rowIndex13.getCell(2);
//        cell42.setText("");
//        XWPFTableCell cell43 = rowIndex13.getCell(3);
//        cell43.setText("");
//
//        XWPFTableRow rowIndex14 = table1.getRow(4);
//        XWPFTableCell cell50 = rowIndex14.getCell(0);
//        cell50.setText("车间喷涂工位数（不含烤房）");
//
//        XWPFTableRow rowIndex15 = table1.getRow(5);
//        XWPFTableCell cell60 = rowIndex15.getCell(0);
//        cell60.setText("平均单面喷漆收费");
//
//        XWPFTableRow rowIndex16 = table1.getRow(6);
//        XWPFTableCell cell70 = rowIndex16.getCell(0);
//        cell70.setText("油漆采购额（不含税）");
//
//        XWPFTableRow rowIndex17 = table1.getRow(7);
//        XWPFTableCell cell80 = rowIndex17.getCell(0);
//        cell80.setText("月漆工工资（元）");
//
//        XWPFTableRow rowIndex18 = table1.getRow(8);
//        XWPFTableCell cell90 = rowIndex18.getCell(0);
//        cell90.setText("烤房数量");
//
//        XWPFTableRow rowIndex19 = table1.getRow(9);
//        XWPFTableCell cell100 = rowIndex19.getCell(0);
//        cell100.setText("返工台次");
//
//
//        //添加标题
//        XWPFParagraph titleParagraphh1 = document.createParagraph();
//        //设置段落居中
//        titleParagraphh1.setAlignment(ParagraphAlignment.LEFT);
//        XWPFRun titleParagraphRunh1 = titleParagraphh1.createRun();
//        titleParagraphRunh1.setText("");
////        titleParagraphRun.setColor("000000");
//        titleParagraphRunh1.setFontSize(17);
//
//
//        //创建表格
//        int roww1 = 11;
//        int columnn1 = 9;
//        XWPFTable tablee1 = document.createTable(roww1, columnn1);
//        setTableWidth(tablee1, "10000");
//        //填充数据
//        XWPFTableRow rowIndexx10 = tablee1.getRow(1);
//        XWPFTableCell celll10 = rowIndexx10.getCell(0);
//        celll10.setText("项目");
//        XWPFTableCell celll11 = rowIndexx10.getCell(1);
//        celll11.setText("改善前3个月");
//        XWPFTableCell celll12 = rowIndexx10.getCell(2);
//        celll12.setText("改善前2个月");
//        XWPFTableCell celll13 = rowIndexx10.getCell(3);
//        celll13.setText("改善前1个月");
//        XWPFTableCell celll14 = rowIndexx10.getCell(4);
//        celll14.setText("改善当月");
//        XWPFTableCell celll15 = rowIndexx10.getCell(5);
//        celll15.setText("改善后1个月");
//        XWPFTableCell celll16 = rowIndexx10.getCell(6);
//        celll16.setText("改善后2个月");
//        XWPFTableCell celll17 = rowIndexx10.getCell(7);
//        celll17.setText("改善后3个月");
//        XWPFTableCell celll18 = rowIndexx10.getCell(8);
//        celll18.setText("平均值");
//
//        XWPFTableRow rowIndexx11 = tablee1.getRow(2);
//        XWPFTableCell celll20 = rowIndexx11.getCell(0);
//        celll20.setText("月喷漆产值（元）");
//        XWPFTableCell celll21 = rowIndexx11.getCell(1);
//        celll21.setText("");
//        XWPFTableCell celll22 = rowIndexx11.getCell(2);
//        celll22.setText("");
//        XWPFTableCell celll23 = rowIndexx11.getCell(3);
//        celll23.setText("");
//        XWPFTableCell celll24 = rowIndexx11.getCell(4);
//        celll24.setText("");
//        XWPFTableCell celll25 = rowIndexx11.getCell(5);
//        celll25.setText("");
//        XWPFTableCell celll26 = rowIndexx11.getCell(6);
//        celll26.setText("");
//        XWPFTableCell celll27 = rowIndexx11.getCell(7);
//        celll27.setText("");
//        XWPFTableCell celll28 = rowIndexx11.getCell(8);
//        celll28.setText("");
//
//        XWPFTableRow rowIndexx12 = tablee1.getRow(3);
//        XWPFTableCell celll30 = rowIndexx12.getCell(0);
//        celll30.setText("喷漆维修台次");
//        XWPFTableCell celll31 = rowIndexx12.getCell(1);
//        celll31.setText("");
//        XWPFTableCell celll32 = rowIndexx12.getCell(2);
//        celll32.setText("");
//        XWPFTableCell celll33 = rowIndexx12.getCell(3);
//        celll33.setText("");
//        XWPFTableCell celll34 = rowIndexx12.getCell(4);
//        celll34.setText("");
//        XWPFTableCell celll35 = rowIndexx12.getCell(5);
//        celll35.setText("");
//        XWPFTableCell celll36 = rowIndexx12.getCell(6);
//        celll36.setText("");
//        XWPFTableCell celll37 = rowIndexx12.getCell(7);
//        celll37.setText("");
//        XWPFTableCell celll38 = rowIndexx12.getCell(8);
//        celll38.setText("");
//
//        XWPFTableRow rowIndexx13 = tablee1.getRow(4);
//        XWPFTableCell celll40 = rowIndexx13.getCell(0);
//        celll40.setText("车间喷漆工人数");
//        XWPFTableCell celll41 = rowIndexx13.getCell(1);
//        celll41.setText("");
//        XWPFTableCell celll42 = rowIndexx13.getCell(2);
//        celll42.setText("");
//        XWPFTableCell celll43 = rowIndexx13.getCell(3);
//        celll43.setText("");
//        XWPFTableCell celll44 = rowIndexx13.getCell(4);
//        celll44.setText("");
//        XWPFTableCell celll45 = rowIndexx13.getCell(5);
//        celll45.setText("");
//        XWPFTableCell celll46 = rowIndexx13.getCell(6);
//        celll46.setText("");
//        XWPFTableCell celll47 = rowIndexx13.getCell(7);
//        celll47.setText("");
//        XWPFTableCell celll48 = rowIndexx13.getCell(8);
//        celll48.setText("");
//
//        XWPFTableRow rowIndexx14 = tablee1.getRow(5);
//        XWPFTableCell celll50 = rowIndexx14.getCell(0);
//        celll50.setText("车间喷涂工位数（不含烤房）");
//        XWPFTableCell celll51 = rowIndexx14.getCell(1);
//        celll51.setText("");
//        XWPFTableCell celll52 = rowIndexx14.getCell(2);
//        celll52.setText("");
//        XWPFTableCell celll53 = rowIndexx14.getCell(3);
//        celll53.setText("");
//        XWPFTableCell celll54 = rowIndexx14.getCell(4);
//        celll54.setText("");
//        XWPFTableCell celll55 = rowIndexx14.getCell(5);
//        celll55.setText("");
//        XWPFTableCell celll56 = rowIndexx14.getCell(6);
//        celll56.setText("");
//        XWPFTableCell celll57 = rowIndexx14.getCell(7);
//        celll57.setText("");
//        XWPFTableCell celll58 = rowIndexx14.getCell(8);
//        celll58.setText("");
//
//        XWPFTableRow rowIndexx15 = tablee1.getRow(6);
//        XWPFTableCell celll60 = rowIndexx15.getCell(0);
//        celll60.setText("平均单面喷漆收费");
//        XWPFTableCell celll61 = rowIndexx15.getCell(1);
//        celll61.setText("");
//        XWPFTableCell celll62 = rowIndexx15.getCell(2);
//        celll62.setText("");
//        XWPFTableCell celll63 = rowIndexx15.getCell(3);
//        celll63.setText("");
//        XWPFTableCell celll64 = rowIndexx15.getCell(4);
//        celll64.setText("");
//        XWPFTableCell celll65 = rowIndexx15.getCell(5);
//        celll65.setText("");
//        XWPFTableCell celll66 = rowIndexx15.getCell(6);
//        celll66.setText("");
//        XWPFTableCell celll67 = rowIndexx15.getCell(7);
//        celll67.setText("");
//        XWPFTableCell celll68 = rowIndexx15.getCell(8);
//        celll68.setText("");
//
//        XWPFTableRow rowIndexx16 = tablee1.getRow(7);
//        XWPFTableCell celll70 = rowIndexx16.getCell(0);
//        celll70.setText("油漆采购额（不含税）");
//        XWPFTableCell celll71 = rowIndexx16.getCell(1);
//        celll71.setText("");
//        XWPFTableCell celll72 = rowIndexx16.getCell(2);
//        celll72.setText("");
//        XWPFTableCell celll73 = rowIndexx16.getCell(3);
//        celll73.setText("");
//        XWPFTableCell celll74 = rowIndexx16.getCell(4);
//        celll74.setText("");
//        XWPFTableCell celll75 = rowIndexx16.getCell(5);
//        celll75.setText("");
//        XWPFTableCell celll76 = rowIndexx16.getCell(6);
//        celll76.setText("");
//        XWPFTableCell celll77 = rowIndexx16.getCell(7);
//        celll77.setText("");
//        XWPFTableCell celll78 = rowIndexx16.getCell(8);
//        celll78.setText("");
//
//        XWPFTableRow rowIndexx17 = tablee1.getRow(8);
//        XWPFTableCell celll80 = rowIndexx17.getCell(0);
//        celll80.setText("月漆工工资（元）");
//        XWPFTableCell celll81 = rowIndexx17.getCell(1);
//        celll81.setText("");
//        XWPFTableCell celll82 = rowIndexx17.getCell(2);
//        celll82.setText("");
//        XWPFTableCell celll83 = rowIndexx17.getCell(3);
//        celll83.setText("");
//        XWPFTableCell celll84 = rowIndexx17.getCell(4);
//        celll84.setText("");
//        XWPFTableCell celll85 = rowIndexx17.getCell(5);
//        celll85.setText("");
//        XWPFTableCell celll86 = rowIndexx17.getCell(6);
//        celll86.setText("");
//        XWPFTableCell celll87 = rowIndexx17.getCell(7);
//        celll87.setText("");
//        XWPFTableCell celll88 = rowIndexx17.getCell(8);
//        celll88.setText("");
//
//        XWPFTableRow rowIndexx18 = tablee1.getRow(9);
//        XWPFTableCell celll90 = rowIndexx18.getCell(0);
//        celll90.setText("烤房数量");
//        XWPFTableCell celll91 = rowIndexx18.getCell(1);
//        celll91.setText("");
//        XWPFTableCell celll92 = rowIndexx18.getCell(2);
//        celll92.setText("");
//        XWPFTableCell celll93 = rowIndexx18.getCell(3);
//        celll93.setText("");
//        XWPFTableCell celll94 = rowIndexx18.getCell(4);
//        celll94.setText("");
//        XWPFTableCell celll95 = rowIndexx18.getCell(5);
//        celll95.setText("");
//        XWPFTableCell celll96 = rowIndexx18.getCell(6);
//        celll96.setText("");
//        XWPFTableCell celll97 = rowIndexx18.getCell(7);
//        celll97.setText("");
//        XWPFTableCell celll98 = rowIndexx18.getCell(8);
//        celll98.setText("");
//
//        XWPFTableRow rowIndexx19 = tablee1.getRow(10);
//        XWPFTableCell celll100 = rowIndexx19.getCell(0);
//        celll100.setText("返工台次");
//        XWPFTableCell celll101 = rowIndexx19.getCell(1);
//        celll101.setText("");
//        XWPFTableCell celll102 = rowIndexx19.getCell(2);
//        celll102.setText("");
//        XWPFTableCell celll103 = rowIndexx19.getCell(3);
//        celll103.setText("");
//        XWPFTableCell celll104 = rowIndexx19.getCell(4);
//        celll104.setText("");
//        XWPFTableCell celll105 = rowIndexx19.getCell(5);
//        celll105.setText("");
//        XWPFTableCell celll106 = rowIndexx19.getCell(6);
//        celll106.setText("");
//        XWPFTableCell celll107 = rowIndexx19.getCell(7);
//        celll107.setText("");
//        XWPFTableCell celll108 = rowIndexx19.getCell(8);
//        celll108.setText("");
//
//
//        //添加标题
//        XWPFParagraph titleParagraph2 = document.createParagraph();
//        //设置段落居中
//        titleParagraph2.setAlignment(ParagraphAlignment.LEFT);
//        XWPFRun titleParagraphRun2 = titleParagraph2.createRun();
//        titleParagraphRun2.setText("单元运营一览");
////        titleParagraphRun.setColor("000000");
//        titleParagraphRun2.setFontSize(17);
//        //创建表格 单元运营一览
//        int row2 = 11;
//        int column2 = 4;
//        XWPFTable table2 = document.createTable(row2, column2);
//        setTableWidth(table2, "10000");
//        //填充数据
//        XWPFTableRow rowIndexa10 = table2.getRow(1);
//        XWPFTableCell cell110 = rowIndexa10.getCell(0);
//        cell110.setText("项目");
//        XWPFTableCell cell111 = rowIndexa10.getCell(1);
//        cell111.setText("行业参考值（范围）");
//        XWPFTableCell cell112 = rowIndexa10.getCell(2);
//        cell112.setText("偏差诊断及建议");
//        XWPFTableCell cell113 = rowIndexa10.getCell(3);
//        cell113.setText("AkzoNobel解决方案");
//
//        XWPFTableRow rowIndexa11 = table2.getRow(2);
//        XWPFTableCell cell120 = rowIndexa11.getCell(0);
//        cell120.setText("单台车平均产值");
//        XWPFTableCell cell121 = rowIndexa11.getCell(1);
//        cell121.setText("850～2299");
//        XWPFTableCell cell122 = rowIndexa11.getCell(2);
//        cell122.setText("");
//        XWPFTableCell cell123 = rowIndexa11.getCell(3);
//        cell123.setText("");
//
//        XWPFTableRow rowIndexa12 = table2.getRow(3);
//        XWPFTableCell cell130 = rowIndexa12.getCell(0);
//        cell130.setText("平均单车面数");
//        XWPFTableCell cell131 = rowIndexa12.getCell(1);
//        cell131.setText("1.8～2.6");
//        XWPFTableCell cell132 = rowIndexa12.getCell(2);
//        cell132.setText("");
//        XWPFTableCell cell133 = rowIndexa12.getCell(3);
//        cell133.setText("");
//
//        XWPFTableRow rowIndexa13 = table2.getRow(4);
//        XWPFTableCell cell140 = rowIndexa13.getCell(0);
//        cell140.setText("月均维修面数");
//        XWPFTableCell cell141 = rowIndexa13.getCell(1);
//        cell141.setText("");
//        XWPFTableCell cell142 = rowIndexa13.getCell(2);
//        cell142.setText("");
//        XWPFTableCell cell143 = rowIndexa13.getCell(3);
//        cell143.setText("");
//
//        XWPFTableRow rowIndexa14 = table2.getRow(5);
//        XWPFTableCell cell150 = rowIndexa14.getCell(0);
//        cell150.setText("单工位维修台次/月");
//        XWPFTableCell cell151 = rowIndexa14.getCell(1);
//        cell151.setText("30～45台月");
//        XWPFTableCell cell152 = rowIndexa14.getCell(2);
//        cell152.setText("");
//        XWPFTableCell cell153 = rowIndexa14.getCell(3);
//        cell153.setText("");
//
//        XWPFTableRow rowIndexa15 = table2.getRow(6);
//        XWPFTableCell cell160 = rowIndexa15.getCell(0);
//        cell160.setText("单工位维修面数/月");
//        XWPFTableCell cell161 = rowIndexa15.getCell(1);
//        cell161.setText("60～75面/月");
//        XWPFTableCell cell162 = rowIndexa15.getCell(2);
//        cell162.setText("");
//        XWPFTableCell cell163 = rowIndexa15.getCell(3);
//        cell163.setText("");
//
//        XWPFTableRow rowIndexa16 = table2.getRow(7);
//        XWPFTableCell cell170 = rowIndexa16.getCell(0);
//        cell170.setText("单工人维修台次/月");
//        XWPFTableCell cell171 = rowIndexa16.getCell(1);
//        cell171.setText("45～60台月");
//        XWPFTableCell cell172 = rowIndexa16.getCell(2);
//        cell172.setText("");
//        XWPFTableCell cell173 = rowIndexa16.getCell(3);
//        cell173.setText("");
//
//        XWPFTableRow rowIndexa17 = table2.getRow(8);
//        XWPFTableCell cell180 = rowIndexa17.getCell(0);
//        cell180.setText("单工人维修面数/月");
//        XWPFTableCell cell181 = rowIndexa17.getCell(1);
//        cell181.setText("90～120面/月");
//        XWPFTableCell cell182 = rowIndexa17.getCell(2);
//        cell182.setText("");
//        XWPFTableCell cell183 = rowIndexa17.getCell(3);
//        cell183.setText("");
//
//        XWPFTableRow rowIndexa18 = table2.getRow(9);
//        XWPFTableCell cell190 = rowIndexa18.getCell(0);
//        cell190.setText("单工位产值（元）");
//
//        XWPFTableRow rowIndexa19 = table2.getRow(10);
//        XWPFTableCell cell1100 = rowIndexa19.getCell(0);
//        cell1100.setText("单工人产值（元）");
//
//
//        //添加标题
//        XWPFParagraph titleParagraphhh1 = document.createParagraph();
//        //设置段落居中
//        titleParagraphhh1.setAlignment(ParagraphAlignment.LEFT);
//        XWPFRun titleParagraphRunhh1 = titleParagraphhh1.createRun();
//        titleParagraphRunhh1.setText("");
////        titleParagraphRun.setColor("000000");
//        titleParagraphRunhh1.setFontSize(17);
//
//
//        //创建表格
//        int roww2 = 11;
//        int columnn2 = 9;
//        XWPFTable tablee2 = document.createTable(roww2, columnn2);
//        setTableWidth(tablee2, "10000");
//        //填充数据
//        XWPFTableRow rowIndexxx10 = tablee2.getRow(1);
//        XWPFTableCell cellll10 = rowIndexxx10.getCell(0);
//        cellll10.setText("项目");
//        XWPFTableCell cellll11 = rowIndexxx10.getCell(1);
//        cellll11.setText("改善前3个月");
//        XWPFTableCell cellll12 = rowIndexxx10.getCell(2);
//        cellll12.setText("改善前2个月");
//        XWPFTableCell cellll13 = rowIndexxx10.getCell(3);
//        cellll13.setText("改善前1个月");
//        XWPFTableCell cellll14 = rowIndexxx10.getCell(4);
//        cellll14.setText("改善当月");
//        XWPFTableCell cellll15 = rowIndexxx10.getCell(5);
//        cellll15.setText("改善后1个月");
//        XWPFTableCell cellll16 = rowIndexxx10.getCell(6);
//        cellll16.setText("改善后2个月");
//        XWPFTableCell cellll17 = rowIndexxx10.getCell(7);
//        cellll17.setText("改善后3个月");
//        XWPFTableCell cellll18 = rowIndexxx10.getCell(8);
//        cellll18.setText("平均值");
//
//        XWPFTableRow rowIndexxx11 = tablee2.getRow(2);
//        XWPFTableCell cellll20 = rowIndexxx11.getCell(0);
//        cellll20.setText("单台车平均产值");
//        XWPFTableCell cellll21 = rowIndexxx11.getCell(1);
//        cellll21.setText("");
//        XWPFTableCell cellll22 = rowIndexxx11.getCell(2);
//        cellll22.setText("");
//        XWPFTableCell cellll23 = rowIndexxx11.getCell(3);
//        cellll23.setText("");
//        XWPFTableCell cellll24 = rowIndexxx11.getCell(4);
//        cellll24.setText("");
//        XWPFTableCell cellll25 = rowIndexxx11.getCell(5);
//        cellll25.setText("");
//        XWPFTableCell cellll26 = rowIndexxx11.getCell(6);
//        cellll26.setText("");
//        XWPFTableCell cellll27 = rowIndexxx11.getCell(7);
//        cellll27.setText("");
//        XWPFTableCell cellll28 = rowIndexxx11.getCell(8);
//        cellll28.setText("");
//
//        XWPFTableRow rowIndexxx12 = tablee2.getRow(3);
//        XWPFTableCell cellll30 = rowIndexxx12.getCell(0);
//        cellll30.setText("平均单车面数");
//        XWPFTableCell cellll31 = rowIndexxx12.getCell(1);
//        cellll31.setText("");
//        XWPFTableCell cellll32 = rowIndexxx12.getCell(2);
//        cellll32.setText("");
//        XWPFTableCell cellll33 = rowIndexxx12.getCell(3);
//        cellll33.setText("");
//        XWPFTableCell cellll34 = rowIndexxx12.getCell(4);
//        cellll34.setText("");
//        XWPFTableCell cellll35 = rowIndexxx12.getCell(5);
//        cellll35.setText("");
//        XWPFTableCell cellll36 = rowIndexxx12.getCell(6);
//        cellll36.setText("");
//        XWPFTableCell cellll37 = rowIndexxx12.getCell(7);
//        cellll37.setText("");
//        XWPFTableCell cellll38 = rowIndexxx12.getCell(8);
//        cellll38.setText("");
//
//        XWPFTableRow rowIndexxx13 = tablee2.getRow(4);
//        XWPFTableCell cellll40 = rowIndexxx13.getCell(0);
//        cellll40.setText("月均维修面数");
//        XWPFTableCell cellll41 = rowIndexxx13.getCell(1);
//        cellll41.setText("");
//        XWPFTableCell cellll42 = rowIndexxx13.getCell(2);
//        cellll42.setText("");
//        XWPFTableCell cellll43 = rowIndexxx13.getCell(3);
//        cellll43.setText("");
//        XWPFTableCell cellll44 = rowIndexxx13.getCell(4);
//        cellll44.setText("");
//        XWPFTableCell cellll45 = rowIndexxx13.getCell(5);
//        cellll45.setText("");
//        XWPFTableCell cellll46 = rowIndexxx13.getCell(6);
//        cellll46.setText("");
//        XWPFTableCell cellll47 = rowIndexxx13.getCell(7);
//        cellll47.setText("");
//        XWPFTableCell cellll48 = rowIndexxx13.getCell(8);
//        cellll48.setText("");
//
//        XWPFTableRow rowIndexxx14 = tablee2.getRow(5);
//        XWPFTableCell cellll50 = rowIndexxx14.getCell(0);
//        cellll50.setText("单工位维修台次/月");
//        XWPFTableCell cellll51 = rowIndexxx14.getCell(1);
//        cellll51.setText("");
//        XWPFTableCell cellll52 = rowIndexxx14.getCell(2);
//        cellll52.setText("");
//        XWPFTableCell cellll53 = rowIndexxx14.getCell(3);
//        cellll53.setText("");
//        XWPFTableCell cellll54 = rowIndexxx14.getCell(4);
//        cellll54.setText("");
//        XWPFTableCell cellll55 = rowIndexxx14.getCell(5);
//        cellll55.setText("");
//        XWPFTableCell cellll56 = rowIndexxx14.getCell(6);
//        cellll56.setText("");
//        XWPFTableCell cellll57 = rowIndexxx14.getCell(7);
//        cellll57.setText("");
//        XWPFTableCell cellll58 = rowIndexxx14.getCell(8);
//        cellll58.setText("");
//
//        XWPFTableRow rowIndexxx15 = tablee2.getRow(6);
//        XWPFTableCell cellll60 = rowIndexxx15.getCell(0);
//        cellll60.setText("单工位维修面数/月");
//        XWPFTableCell cellll61 = rowIndexxx15.getCell(1);
//        cellll61.setText("");
//        XWPFTableCell cellll62 = rowIndexxx15.getCell(2);
//        cellll62.setText("");
//        XWPFTableCell cellll63 = rowIndexxx15.getCell(3);
//        cellll63.setText("");
//        XWPFTableCell cellll64 = rowIndexxx15.getCell(4);
//        cellll64.setText("");
//        XWPFTableCell cellll65 = rowIndexxx15.getCell(5);
//        cellll65.setText("");
//        XWPFTableCell cellll66 = rowIndexxx15.getCell(6);
//        cellll66.setText("");
//        XWPFTableCell cellll67 = rowIndexxx15.getCell(7);
//        cellll67.setText("");
//        XWPFTableCell cellll68 = rowIndexxx15.getCell(8);
//        cellll68.setText("");
//
//        XWPFTableRow rowIndexxx16 = tablee2.getRow(7);
//        XWPFTableCell cellll70 = rowIndexxx16.getCell(0);
//        cellll70.setText("单工人维修台次/月");
//        XWPFTableCell cellll71 = rowIndexxx16.getCell(1);
//        cellll71.setText("");
//        XWPFTableCell cellll72 = rowIndexxx16.getCell(2);
//        cellll72.setText("");
//        XWPFTableCell cellll73 = rowIndexxx16.getCell(3);
//        cellll73.setText("");
//        XWPFTableCell cellll74 = rowIndexxx16.getCell(4);
//        cellll74.setText("");
//        XWPFTableCell cellll75 = rowIndexxx16.getCell(5);
//        cellll75.setText("");
//        XWPFTableCell cellll76 = rowIndexxx16.getCell(6);
//        cellll76.setText("");
//        XWPFTableCell cellll77 = rowIndexxx16.getCell(7);
//        cellll77.setText("");
//        XWPFTableCell cellll78 = rowIndexxx16.getCell(8);
//        cellll78.setText("");
//
//        XWPFTableRow rowIndexxx17 = tablee2.getRow(8);
//        XWPFTableCell cellll80 = rowIndexxx17.getCell(0);
//        cellll80.setText("单工人维修面数/月");
//        XWPFTableCell cellll81 = rowIndexxx17.getCell(1);
//        cellll81.setText("");
//        XWPFTableCell cellll82 = rowIndexxx17.getCell(2);
//        cellll82.setText("");
//        XWPFTableCell cellll83 = rowIndexxx17.getCell(3);
//        cellll83.setText("");
//        XWPFTableCell cellll84 = rowIndexxx17.getCell(4);
//        cellll84.setText("");
//        XWPFTableCell cellll85 = rowIndexxx17.getCell(5);
//        cellll85.setText("");
//        XWPFTableCell cellll86 = rowIndexxx17.getCell(6);
//        cellll86.setText("");
//        XWPFTableCell cellll87 = rowIndexxx17.getCell(7);
//        cellll87.setText("");
//        XWPFTableCell cellll88 = rowIndexxx17.getCell(8);
//        cellll88.setText("");
//
//        XWPFTableRow rowIndexxx18 = tablee2.getRow(9);
//        XWPFTableCell cellll90 = rowIndexxx18.getCell(0);
//        cellll90.setText("单工位产值（元）");
//        XWPFTableCell cellll91 = rowIndexxx18.getCell(1);
//        cellll91.setText("");
//        XWPFTableCell cellll92 = rowIndexxx18.getCell(2);
//        cellll92.setText("");
//        XWPFTableCell cellll93 = rowIndexxx18.getCell(3);
//        cellll93.setText("");
//        XWPFTableCell cellll94 = rowIndexxx18.getCell(4);
//        cellll94.setText("");
//        XWPFTableCell cellll95 = rowIndexxx18.getCell(5);
//        cellll95.setText("");
//        XWPFTableCell cellll96 = rowIndexxx18.getCell(6);
//        cellll96.setText("");
//        XWPFTableCell cellll97 = rowIndexxx18.getCell(7);
//        cellll97.setText("");
//        XWPFTableCell cellll98 = rowIndexxx18.getCell(8);
//        cellll98.setText("");
//
//        XWPFTableRow rowIndexxx19 = tablee2.getRow(10);
//        XWPFTableCell cellll100 = rowIndexxx19.getCell(0);
//        cellll100.setText("单工人产值（元）");
//        XWPFTableCell cellll101 = rowIndexxx19.getCell(1);
//        cellll101.setText("");
//        XWPFTableCell cellll102 = rowIndexxx19.getCell(2);
//        cellll102.setText("");
//        XWPFTableCell cellll103 = rowIndexxx19.getCell(3);
//        cellll103.setText("");
//        XWPFTableCell cellll104 = rowIndexxx19.getCell(4);
//        cellll104.setText("");
//        XWPFTableCell cellll105 = rowIndexxx19.getCell(5);
//        cellll105.setText("");
//        XWPFTableCell cellll106 = rowIndexxx19.getCell(6);
//        cellll106.setText("");
//        XWPFTableCell cellll107 = rowIndexxx19.getCell(7);
//        cellll107.setText("");
//        XWPFTableCell cellll108 = rowIndexxx19.getCell(8);
//        cellll108.setText("");
//
//
//        //添加标题
//        XWPFParagraph titleParagraph3 = document.createParagraph();
//        //设置段落居中
//        titleParagraph3.setAlignment(ParagraphAlignment.LEFT);
//        XWPFRun titleParagraphRun3 = titleParagraph3.createRun();
//        titleParagraphRun3.setText("总体产能一览");
////        titleParagraphRun.setColor("000000");
//        titleParagraphRun3.setFontSize(17);
//
//        //创建表格 总体产能一览
//        int row3 = 11;
//        int column3 = 4;
//        XWPFTable table3 = document.createTable(row3, column3);
//        setTableWidth(table3, "10000");
//        //填充数据
//        XWPFTableRow rowIndexaaa10 = table3.getRow(1);
//        XWPFTableCell celll110 = rowIndexaaa10.getCell(0);
//        celll110.setText("项目");
//        XWPFTableCell celll111 = rowIndexaaa10.getCell(1);
//        celll111.setText("行业参考值（范围）");
//        XWPFTableCell celll112 = rowIndexaaa10.getCell(2);
//        celll112.setText("偏差诊断及建议");
//        XWPFTableCell celll113 = rowIndexaaa10.getCell(3);
//        celll113.setText("AkzoNobel解决方案");
//
//        XWPFTableRow rowIndexaa11 = table3.getRow(2);
//        XWPFTableCell celll120 = rowIndexaa11.getCell(0);
//        celll120.setText("目前烤房最大产能（台）");
//        XWPFTableCell celll121 = rowIndexaa11.getCell(1);
//        celll121.setText("165台/月");
//        XWPFTableCell celll122 = rowIndexaa11.getCell(2);
//        celll122.setText("");
//        XWPFTableCell celll123 = rowIndexaa11.getCell(3);
//        celll123.setText("");
//
//        XWPFTableRow rowIndexaa12 = table3.getRow(3);
//        XWPFTableCell celll130 = rowIndexaa12.getCell(0);
//        celll130.setText("目前烤房最大产能（面）");
//        XWPFTableCell celll131 = rowIndexaa12.getCell(1);
//        celll131.setText("300～450件/月");
//        XWPFTableCell celll132 = rowIndexaa12.getCell(2);
//        celll132.setText("");
//        XWPFTableCell celll133 = rowIndexaa12.getCell(3);
//        celll133.setText("");
//
//        XWPFTableRow rowIndexaa13 = table3.getRow(4);
//        XWPFTableCell celll140 = rowIndexaa13.getCell(0);
//        celll140.setText("烤房利用率");
//        XWPFTableCell celll141 = rowIndexaa13.getCell(1);
//        celll141.setText("80%");
//        XWPFTableCell celll142 = rowIndexaa13.getCell(2);
//        celll142.setText("");
//        XWPFTableCell celll143 = rowIndexaa13.getCell(3);
//        celll143.setText("");
//
//        XWPFTableRow rowIndexaa14 = table3.getRow(5);
//        XWPFTableCell celll150 = rowIndexaa14.getCell(0);
//        celll150.setText("目前工人最大产能（台）");
//        XWPFTableCell celll151 = rowIndexaa14.getCell(1);
//        celll151.setText("45～60台/月");
//        XWPFTableCell celll152 = rowIndexaa14.getCell(2);
//        celll152.setText("");
//        XWPFTableCell celll153 = rowIndexaa14.getCell(3);
//        celll153.setText("");
//
//        XWPFTableRow rowIndexaa15 = table3.getRow(6);
//        XWPFTableCell celll160 = rowIndexaa15.getCell(0);
//        celll160.setText("目前工人最大产能（面）");
//        XWPFTableCell celll161 = rowIndexaa15.getCell(1);
//        celll161.setText("90～120面/月");
//        XWPFTableCell celll162 = rowIndexaa15.getCell(2);
//        celll162.setText("");
//        XWPFTableCell celll163 = rowIndexaa15.getCell(3);
//        celll163.setText("");
//
//        XWPFTableRow rowIndexaa16 = table3.getRow(7);
//        XWPFTableCell celll170 = rowIndexaa16.getCell(0);
//        celll170.setText("工人利用率");
//        XWPFTableCell celll171 = rowIndexaa16.getCell(1);
//        celll171.setText("80%");
//        XWPFTableCell celll172 = rowIndexaa16.getCell(2);
//        celll172.setText("");
//        XWPFTableCell celll173 = rowIndexaa16.getCell(3);
//        celll173.setText("");
//
//        XWPFTableRow rowIndexaa17 = table3.getRow(8);
//        XWPFTableCell celll180 = rowIndexaa17.getCell(0);
//        celll180.setText("目前工位最大产能（台）");
//        XWPFTableCell celll181 = rowIndexaa17.getCell(1);
//        celll181.setText("单工位30～45台/月");
//        XWPFTableCell celll182 = rowIndexaa17.getCell(2);
//        celll182.setText("");
//        XWPFTableCell celll183 = rowIndexaa17.getCell(3);
//        celll183.setText("");
//
//        XWPFTableRow rowIndexaa18 = table3.getRow(9);
//        XWPFTableCell celll190 = rowIndexaa18.getCell(0);
//        celll190.setText("目前工位最大产能（面）");
//        XWPFTableCell celll191 = rowIndexaa18.getCell(1);
//        celll191.setText("单工位60～75面/月");
//        XWPFTableCell celll192 = rowIndexaa18.getCell(2);
//        celll192.setText("");
//        XWPFTableCell celll193 = rowIndexaa18.getCell(3);
//        celll193.setText("");
//
//        XWPFTableRow rowIndexaa19 = table3.getRow(10);
//        XWPFTableCell celll1100 = rowIndexaa19.getCell(0);
//        celll1100.setText("工位利用率");
//        XWPFTableCell celll1101 = rowIndexaa19.getCell(1);
//        celll1101.setText("");
//        XWPFTableCell celll1102 = rowIndexaa19.getCell(2);
//        celll1102.setText("");
//        XWPFTableCell celll1103 = rowIndexaa19.getCell(3);
//        celll1103.setText("");
//
//
//        //添加标题
//        XWPFParagraph titleParagraphhhh1 = document.createParagraph();
//        //设置段落居中
//        titleParagraphhhh1.setAlignment(ParagraphAlignment.LEFT);
//        XWPFRun titleParagraphRunhhh1 = titleParagraphhhh1.createRun();
//        titleParagraphRunhhh1.setText("");
////        titleParagraphRun.setColor("000000");
//        titleParagraphRunhhh1.setFontSize(17);
//
//
//        //创建表格
//        int roww3 = 11;
//        int columnn3 = 9;
//        XWPFTable tablee3 = document.createTable(roww3, columnn3);
//        setTableWidth(tablee3, "10000");
//        //填充数据
//        XWPFTableRow rowIndexxxx10 = tablee3.getRow(1);
//        XWPFTableCell celllll10 = rowIndexxxx10.getCell(0);
//        celllll10.setText("项目");
//        XWPFTableCell celllll11 = rowIndexxxx10.getCell(1);
//        celllll11.setText("改善前3个月");
//        XWPFTableCell celllll12 = rowIndexxxx10.getCell(2);
//        celllll12.setText("改善前2个月");
//        XWPFTableCell celllll13 = rowIndexxxx10.getCell(3);
//        celllll13.setText("改善前1个月");
//        XWPFTableCell celllll14 = rowIndexxxx10.getCell(4);
//        celllll14.setText("改善当月");
//        XWPFTableCell celllll15 = rowIndexxxx10.getCell(5);
//        celllll15.setText("改善后1个月");
//        XWPFTableCell celllll16 = rowIndexxxx10.getCell(6);
//        celllll16.setText("改善后2个月");
//        XWPFTableCell celllll17 = rowIndexxxx10.getCell(7);
//        celllll17.setText("改善后3个月");
//        XWPFTableCell celllll18 = rowIndexxxx10.getCell(8);
//        celllll18.setText("平均值");
//
//        XWPFTableRow rowIndexxxx11 = tablee3.getRow(2);
//        XWPFTableCell celllll20 = rowIndexxxx11.getCell(0);
//        celllll20.setText("目前烤房最大产能（台）");
//        XWPFTableCell celllll21 = rowIndexxxx11.getCell(1);
//        celllll21.setText("");
//        XWPFTableCell celllll22 = rowIndexxxx11.getCell(2);
//        celllll22.setText("");
//        XWPFTableCell celllll23 = rowIndexxxx11.getCell(3);
//        celllll23.setText("");
//        XWPFTableCell celllll24 = rowIndexxxx11.getCell(4);
//        celllll24.setText("");
//        XWPFTableCell celllll25 = rowIndexxxx11.getCell(5);
//        celllll25.setText("");
//        XWPFTableCell celllll26 = rowIndexxxx11.getCell(6);
//        celllll26.setText("");
//        XWPFTableCell celllll27 = rowIndexxxx11.getCell(7);
//        celllll27.setText("");
//        XWPFTableCell celllll28 = rowIndexxxx11.getCell(8);
//        celllll28.setText("");
//
//        XWPFTableRow rowIndexxxx12 = tablee3.getRow(3);
//        XWPFTableCell celllll30 = rowIndexxxx12.getCell(0);
//        celllll30.setText("目前烤房最大产能（面）");
//        XWPFTableCell celllll31 = rowIndexxxx12.getCell(1);
//        celllll31.setText("");
//        XWPFTableCell celllll32 = rowIndexxxx12.getCell(2);
//        celllll32.setText("");
//        XWPFTableCell celllll33 = rowIndexxxx12.getCell(3);
//        celllll33.setText("");
//        XWPFTableCell celllll34 = rowIndexxxx12.getCell(4);
//        celllll34.setText("");
//        XWPFTableCell celllll35 = rowIndexxxx12.getCell(5);
//        celllll35.setText("");
//        XWPFTableCell celllll36 = rowIndexxxx12.getCell(6);
//        celllll36.setText("");
//        XWPFTableCell celllll37 = rowIndexxxx12.getCell(7);
//        celllll37.setText("");
//        XWPFTableCell celllll38 = rowIndexxxx12.getCell(8);
//        celllll38.setText("");
//
//        XWPFTableRow rowIndexxxx13 = tablee3.getRow(4);
//        XWPFTableCell celllll40 = rowIndexxxx13.getCell(0);
//        celllll40.setText("烤房利用率");
//        XWPFTableCell celllll41 = rowIndexxxx13.getCell(1);
//        celllll41.setText("");
//        XWPFTableCell celllll42 = rowIndexxxx13.getCell(2);
//        celllll42.setText("");
//        XWPFTableCell celllll43 = rowIndexxxx13.getCell(3);
//        celllll43.setText("");
//        XWPFTableCell celllll44 = rowIndexxxx13.getCell(4);
//        celllll44.setText("");
//        XWPFTableCell celllll45 = rowIndexxxx13.getCell(5);
//        celllll45.setText("");
//        XWPFTableCell celllll46 = rowIndexxxx13.getCell(6);
//        celllll46.setText("");
//        XWPFTableCell celllll47 = rowIndexxxx13.getCell(7);
//        celllll47.setText("");
//        XWPFTableCell celllll48 = rowIndexxxx13.getCell(8);
//        celllll48.setText("");
//
//        XWPFTableRow rowIndexxxx14 = tablee3.getRow(5);
//        XWPFTableCell celllll50 = rowIndexxxx14.getCell(0);
//        celllll50.setText("目前工人最大产能（台）");
//        XWPFTableCell celllll51 = rowIndexxxx14.getCell(1);
//        celllll51.setText("");
//        XWPFTableCell celllll52 = rowIndexxxx14.getCell(2);
//        celllll52.setText("");
//        XWPFTableCell celllll53 = rowIndexxxx14.getCell(3);
//        celllll53.setText("");
//        XWPFTableCell celllll54 = rowIndexxxx14.getCell(4);
//        celllll54.setText("");
//        XWPFTableCell celllll55 = rowIndexxxx14.getCell(5);
//        celllll55.setText("");
//        XWPFTableCell celllll56 = rowIndexxxx14.getCell(6);
//        celllll56.setText("");
//        XWPFTableCell celllll57 = rowIndexxxx14.getCell(7);
//        celllll57.setText("");
//        XWPFTableCell celllll58 = rowIndexxxx14.getCell(8);
//        celllll58.setText("");
//
//        XWPFTableRow rowIndexxxx15 = tablee3.getRow(6);
//        XWPFTableCell celllll60 = rowIndexxxx15.getCell(0);
//        celllll60.setText("目前工人最大产能（面）");
//        XWPFTableCell celllll61 = rowIndexxxx15.getCell(1);
//        celllll61.setText("");
//        XWPFTableCell celllll62 = rowIndexxxx15.getCell(2);
//        celllll62.setText("");
//        XWPFTableCell celllll63 = rowIndexxxx15.getCell(3);
//        celllll63.setText("");
//        XWPFTableCell celllll64 = rowIndexxxx15.getCell(4);
//        celllll64.setText("");
//        XWPFTableCell celllll65 = rowIndexxxx15.getCell(5);
//        celllll65.setText("");
//        XWPFTableCell celllll66 = rowIndexxxx15.getCell(6);
//        celllll66.setText("");
//        XWPFTableCell celllll67 = rowIndexxxx15.getCell(7);
//        celllll67.setText("");
//        XWPFTableCell celllll68 = rowIndexxxx15.getCell(8);
//        celllll68.setText("");
//
//        XWPFTableRow rowIndexxxx16 = tablee3.getRow(7);
//        XWPFTableCell celllll70 = rowIndexxxx16.getCell(0);
//        celllll70.setText("工人利用率");
//        XWPFTableCell celllll71 = rowIndexxxx16.getCell(1);
//        celllll71.setText("");
//        XWPFTableCell celllll72 = rowIndexxxx16.getCell(2);
//        celllll72.setText("");
//        XWPFTableCell celllll73 = rowIndexxxx16.getCell(3);
//        celllll73.setText("");
//        XWPFTableCell celllll74 = rowIndexxxx16.getCell(4);
//        celllll74.setText("");
//        XWPFTableCell celllll75 = rowIndexxxx16.getCell(5);
//        celllll75.setText("");
//        XWPFTableCell celllll76 = rowIndexxxx16.getCell(6);
//        celllll76.setText("");
//        XWPFTableCell celllll77 = rowIndexxxx16.getCell(7);
//        celllll77.setText("");
//        XWPFTableCell celllll78 = rowIndexxxx16.getCell(8);
//        celllll78.setText("");
//
//        XWPFTableRow rowIndexxxx17 = tablee3.getRow(8);
//        XWPFTableCell celllll80 = rowIndexxxx17.getCell(0);
//        celllll80.setText("目前工位最大产能（台）");
//        XWPFTableCell celllll81 = rowIndexxxx17.getCell(1);
//        celllll81.setText("");
//        XWPFTableCell celllll82 = rowIndexxxx17.getCell(2);
//        celllll82.setText("");
//        XWPFTableCell celllll83 = rowIndexxxx17.getCell(3);
//        celllll83.setText("");
//        XWPFTableCell celllll84 = rowIndexxxx17.getCell(4);
//        celllll84.setText("");
//        XWPFTableCell celllll85 = rowIndexxxx17.getCell(5);
//        celllll85.setText("");
//        XWPFTableCell celllll86 = rowIndexxxx17.getCell(6);
//        celllll86.setText("");
//        XWPFTableCell celllll87 = rowIndexxxx17.getCell(7);
//        celllll87.setText("");
//        XWPFTableCell celllll88 = rowIndexxxx17.getCell(8);
//        celllll88.setText("");
//
//        XWPFTableRow rowIndexxxx18 = tablee3.getRow(9);
//        XWPFTableCell celllll90 = rowIndexxxx18.getCell(0);
//        celllll90.setText("目前工位最大产能（面）");
//        XWPFTableCell celllll91 = rowIndexxxx18.getCell(1);
//        celllll91.setText("");
//        XWPFTableCell celllll92 = rowIndexxxx18.getCell(2);
//        celllll92.setText("");
//        XWPFTableCell celllll93 = rowIndexxxx18.getCell(3);
//        celllll93.setText("");
//        XWPFTableCell celllll94 = rowIndexxxx18.getCell(4);
//        celllll94.setText("");
//        XWPFTableCell celllll95 = rowIndexxxx18.getCell(5);
//        celllll95.setText("");
//        XWPFTableCell celllll96 = rowIndexxxx18.getCell(6);
//        celllll96.setText("");
//        XWPFTableCell celllll97 = rowIndexxxx18.getCell(7);
//        celllll97.setText("");
//        XWPFTableCell celllll98 = rowIndexxxx18.getCell(8);
//        celllll98.setText("");
//
//        XWPFTableRow rowIndexxxx19 = tablee3.getRow(10);
//        XWPFTableCell celllll100 = rowIndexxxx19.getCell(0);
//        celllll100.setText("工位利用率");
//        XWPFTableCell celllll101 = rowIndexxxx19.getCell(1);
//        celllll101.setText("");
//        XWPFTableCell celllll102 = rowIndexxxx19.getCell(2);
//        celllll102.setText("");
//        XWPFTableCell celllll103 = rowIndexxxx19.getCell(3);
//        celllll103.setText("");
//        XWPFTableCell celllll104 = rowIndexxxx19.getCell(4);
//        celllll104.setText("");
//        XWPFTableCell celllll105 = rowIndexxxx19.getCell(5);
//        celllll105.setText("");
//        XWPFTableCell celllll106 = rowIndexxxx19.getCell(6);
//        celllll106.setText("");
//        XWPFTableCell celllll107 = rowIndexxxx19.getCell(7);
//        celllll107.setText("");
//        XWPFTableCell celllll108 = rowIndexxxx19.getCell(8);
//        celllll108.setText("");
//
//        //添加标题
//        XWPFParagraph titleParagraph4 = document.createParagraph();
//        //设置段落居中
//        titleParagraph4.setAlignment(ParagraphAlignment.LEFT);
//        XWPFRun titleParagraphRun4 = titleParagraph4.createRun();
//        titleParagraphRun4.setText("经济性数据");
////        titleParagraphRun.setColor("000000");
//        titleParagraphRun4.setFontSize(17);
//
//        //创建表格 经济性数据
//        int row4 = 9;
//        int column4 = 4;
//        XWPFTable table4 = document.createTable(row4, column4);
//        setTableWidth(table4, "10000");
//        //填充数据
//        XWPFTableRow rowIndexaaaa10 = table4.getRow(1);
//        XWPFTableCell cellll110 = rowIndexaaaa10.getCell(0);
//        cellll110.setText("项目");
//        XWPFTableCell cellll111 = rowIndexaaaa10.getCell(1);
//        cellll111.setText("行业参考值（范围）");
//        XWPFTableCell cellll112 = rowIndexaaaa10.getCell(2);
//        cellll112.setText("偏差诊断及建议");
//        XWPFTableCell cellll113 = rowIndexaaaa10.getCell(3);
//        cellll113.setText("AkzoNobel解决方案");
//
//        XWPFTableRow rowIndexaaa11 = table4.getRow(2);
//        XWPFTableCell cellll120 = rowIndexaaa11.getCell(0);
//        cellll120.setText("返工率");
//        XWPFTableCell cellll121 = rowIndexaaa11.getCell(1);
//        cellll121.setText("<2%");
//        XWPFTableCell cellll122 = rowIndexaaa11.getCell(2);
//        cellll122.setText("");
//        XWPFTableCell cellll123 = rowIndexaaa11.getCell(3);
//        cellll123.setText("");
//
//        XWPFTableRow rowIndexaaa12 = table4.getRow(3);
//        XWPFTableCell cellll130 = rowIndexaaa12.getCell(0);
//        cellll130.setText("油漆成本占产值额比例");
//        XWPFTableCell cellll131 = rowIndexaaa12.getCell(1);
//        cellll131.setText("");
//        XWPFTableCell cellll132 = rowIndexaaa12.getCell(2);
//        cellll132.setText("");
//        XWPFTableCell cellll133 = rowIndexaaa12.getCell(3);
//        cellll133.setText("");
//
//        XWPFTableRow rowIndexaaa13 = table4.getRow(4);
//        XWPFTableCell cellll140 = rowIndexaaa13.getCell(0);
//        cellll140.setText("人工成本占产值额比例");
//        XWPFTableCell cellll141 = rowIndexaaa13.getCell(1);
//        cellll141.setText("");
//        XWPFTableCell cellll142 = rowIndexaaa13.getCell(2);
//        cellll142.setText("");
//        XWPFTableCell cellll143 = rowIndexaaa13.getCell(3);
//        cellll143.setText("");
//
//        XWPFTableRow rowIndexaaa14 = table4.getRow(5);
//        XWPFTableCell cellll150 = rowIndexaaa14.getCell(0);
//        cellll150.setText("单面材料成本");
//        XWPFTableCell cellll151 = rowIndexaaa14.getCell(1);
//        cellll151.setText("油性漆65～85；水性漆85～老白5");
//        XWPFTableCell cellll152 = rowIndexaaa14.getCell(2);
//        cellll152.setText("");
//        XWPFTableCell cellll153 = rowIndexaaa14.getCell(3);
//        cellll153.setText("");
//
//        XWPFTableRow rowIndexaaa15 = table4.getRow(6);
//        XWPFTableCell cellll160 = rowIndexaaa15.getCell(0);
//        cellll160.setText("单面人工成本");
//        XWPFTableCell cellll161 = rowIndexaaa15.getCell(1);
//        cellll161.setText("60～80/部件");
//        XWPFTableCell cellll162 = rowIndexaaa15.getCell(2);
//        cellll162.setText("");
//        XWPFTableCell cellll163 = rowIndexaaa15.getCell(3);
//        cellll163.setText("");
//
//        XWPFTableRow rowIndexaaa16 = table4.getRow(7);
//        XWPFTableCell cellll170 = rowIndexaaa16.getCell(0);
//        cellll170.setText("车间毛利");
//        XWPFTableCell cellll171 = rowIndexaaa16.getCell(1);
//        cellll171.setText("");
//        XWPFTableCell cellll172 = rowIndexaaa16.getCell(2);
//        cellll172.setText("");
//        XWPFTableCell cellll173 = rowIndexaaa16.getCell(3);
//        cellll173.setText("");
//
//        XWPFTableRow rowIndexaaa17 = table4.getRow(8);
//        XWPFTableCell cellll180 = rowIndexaaa17.getCell(0);
//        cellll180.setText("车间毛利率");
//        XWPFTableCell cellll181 = rowIndexaaa17.getCell(1);
//        cellll181.setText("˃45%");
//        XWPFTableCell cellll182 = rowIndexaaa17.getCell(2);
//        cellll182.setText("");
//        XWPFTableCell cellll183 = rowIndexaaa17.getCell(3);
//        cellll183.setText("");
//
//
//        //添加标题
//        XWPFParagraph titleParagraphhhhh1 = document.createParagraph();
//        //设置段落居中
//        titleParagraphhhhh1.setAlignment(ParagraphAlignment.LEFT);
//        XWPFRun titleParagraphRunhhhh1 = titleParagraphhhhh1.createRun();
//        titleParagraphRunhhhh1.setText("");
////        titleParagraphRun.setColor("000000");
//        titleParagraphRunhhhh1.setFontSize(17);
//
//
//        //创建表格
//        int roww4 = 9;
//        int columnn4 = 9;
//        XWPFTable tablee4 = document.createTable(roww4, columnn4);
//        setTableWidth(tablee4, "10000");
//        //填充数据
//        XWPFTableRow rowIndexxxxx10 = tablee4.getRow(1);
//        XWPFTableCell cellllll10 = rowIndexxxxx10.getCell(0);
//        cellllll10.setText("项目");
//        XWPFTableCell cellllll11 = rowIndexxxxx10.getCell(1);
//        cellllll11.setText("改善前3个月");
//        XWPFTableCell cellllll12 = rowIndexxxxx10.getCell(2);
//        cellllll12.setText("改善前2个月");
//        XWPFTableCell cellllll13 = rowIndexxxxx10.getCell(3);
//        cellllll13.setText("改善前1个月");
//        XWPFTableCell cellllll14 = rowIndexxxxx10.getCell(4);
//        cellllll14.setText("改善当月");
//        XWPFTableCell cellllll15 = rowIndexxxxx10.getCell(5);
//        cellllll15.setText("改善后1个月");
//        XWPFTableCell cellllll16 = rowIndexxxxx10.getCell(6);
//        cellllll16.setText("改善后2个月");
//        XWPFTableCell cellllll17 = rowIndexxxxx10.getCell(7);
//        cellllll17.setText("改善后3个月");
//        XWPFTableCell cellllll18 = rowIndexxxxx10.getCell(8);
//        cellllll18.setText("平均值");
//
//        XWPFTableRow rowIndexxxxx11 = tablee4.getRow(2);
//        XWPFTableCell cellllll20 = rowIndexxxxx11.getCell(0);
//        cellllll20.setText("返工率");
//        XWPFTableCell cellllll21 = rowIndexxxxx11.getCell(1);
//        cellllll21.setText("");
//        XWPFTableCell cellllll22 = rowIndexxxxx11.getCell(2);
//        cellllll22.setText("");
//        XWPFTableCell cellllll23 = rowIndexxxxx11.getCell(3);
//        cellllll23.setText("");
//        XWPFTableCell cellllll24 = rowIndexxxxx11.getCell(4);
//        cellllll24.setText("");
//        XWPFTableCell cellllll25 = rowIndexxxxx11.getCell(5);
//        cellllll25.setText("");
//        XWPFTableCell cellllll26 = rowIndexxxxx11.getCell(6);
//        cellllll26.setText("");
//        XWPFTableCell cellllll27 = rowIndexxxxx11.getCell(7);
//        cellllll27.setText("");
//        XWPFTableCell cellllll28 = rowIndexxxxx11.getCell(8);
//        cellllll28.setText("");
//
//        XWPFTableRow rowIndexxxxx12 = tablee4.getRow(3);
//        XWPFTableCell cellllll30 = rowIndexxxxx12.getCell(0);
//        cellllll30.setText("油漆成本占产值额比例");
//        XWPFTableCell cellllll31 = rowIndexxxxx12.getCell(1);
//        cellllll31.setText("");
//        XWPFTableCell cellllll32 = rowIndexxxxx12.getCell(2);
//        cellllll32.setText("");
//        XWPFTableCell cellllll33 = rowIndexxxxx12.getCell(3);
//        cellllll33.setText("");
//        XWPFTableCell cellllll34 = rowIndexxxxx12.getCell(4);
//        cellllll34.setText("");
//        XWPFTableCell cellllll35 = rowIndexxxxx12.getCell(5);
//        cellllll35.setText("");
//        XWPFTableCell cellllll36 = rowIndexxxxx12.getCell(6);
//        cellllll36.setText("");
//        XWPFTableCell cellllll37 = rowIndexxxxx12.getCell(7);
//        cellllll37.setText("");
//        XWPFTableCell cellllll38 = rowIndexxxxx12.getCell(8);
//        cellllll38.setText("");
//
//        XWPFTableRow rowIndexxxxx13 = tablee4.getRow(4);
//        XWPFTableCell cellllll40 = rowIndexxxxx13.getCell(0);
//        cellllll40.setText("人工成本占产值额比例");
//        XWPFTableCell cellllll41 = rowIndexxxxx13.getCell(1);
//        cellllll41.setText("");
//        XWPFTableCell cellllll42 = rowIndexxxxx13.getCell(2);
//        cellllll42.setText("");
//        XWPFTableCell cellllll43 = rowIndexxxxx13.getCell(3);
//        cellllll43.setText("");
//        XWPFTableCell cellllll44 = rowIndexxxxx13.getCell(4);
//        cellllll44.setText("");
//        XWPFTableCell cellllll45 = rowIndexxxxx13.getCell(5);
//        cellllll45.setText("");
//        XWPFTableCell cellllll46 = rowIndexxxxx13.getCell(6);
//        cellllll46.setText("");
//        XWPFTableCell cellllll47 = rowIndexxxxx13.getCell(7);
//        cellllll47.setText("");
//        XWPFTableCell cellllll48 = rowIndexxxxx13.getCell(8);
//        cellllll48.setText("");
//
//        XWPFTableRow rowIndexxxxx14 = tablee4.getRow(5);
//        XWPFTableCell cellllll50 = rowIndexxxxx14.getCell(0);
//        cellllll50.setText("单面材料成本");
//        XWPFTableCell cellllll51 = rowIndexxxxx14.getCell(1);
//        cellllll51.setText("");
//        XWPFTableCell cellllll52 = rowIndexxxxx14.getCell(2);
//        cellllll52.setText("");
//        XWPFTableCell cellllll53 = rowIndexxxxx14.getCell(3);
//        cellllll53.setText("");
//        XWPFTableCell cellllll54 = rowIndexxxxx14.getCell(4);
//        cellllll54.setText("");
//        XWPFTableCell cellllll55 = rowIndexxxxx14.getCell(5);
//        cellllll55.setText("");
//        XWPFTableCell cellllll56 = rowIndexxxxx14.getCell(6);
//        cellllll56.setText("");
//        XWPFTableCell cellllll57 = rowIndexxxxx14.getCell(7);
//        cellllll57.setText("");
//        XWPFTableCell cellllll58 = rowIndexxxxx14.getCell(8);
//        cellllll58.setText("");
//
//        XWPFTableRow rowIndexxxxx15 = tablee4.getRow(6);
//        XWPFTableCell cellllll60 = rowIndexxxxx15.getCell(0);
//        cellllll60.setText("单面人工成本");
//        XWPFTableCell cellllll61 = rowIndexxxxx15.getCell(1);
//        cellllll61.setText("");
//        XWPFTableCell cellllll62 = rowIndexxxxx15.getCell(2);
//        cellllll62.setText("");
//        XWPFTableCell cellllll63 = rowIndexxxxx15.getCell(3);
//        cellllll63.setText("");
//        XWPFTableCell cellllll64 = rowIndexxxxx15.getCell(4);
//        cellllll64.setText("");
//        XWPFTableCell cellllll65 = rowIndexxxxx15.getCell(5);
//        cellllll65.setText("");
//        XWPFTableCell cellllll66 = rowIndexxxxx15.getCell(6);
//        cellllll66.setText("");
//        XWPFTableCell cellllll67 = rowIndexxxxx15.getCell(7);
//        cellllll67.setText("");
//        XWPFTableCell cellllll68 = rowIndexxxxx15.getCell(8);
//        cellllll68.setText("");
//
//        XWPFTableRow rowIndexxxxx16 = tablee4.getRow(7);
//        XWPFTableCell cellllll70 = rowIndexxxxx16.getCell(0);
//        cellllll70.setText("车间毛利");
//        XWPFTableCell cellllll71 = rowIndexxxxx16.getCell(1);
//        cellllll71.setText("");
//        XWPFTableCell cellllll72 = rowIndexxxxx16.getCell(2);
//        cellllll72.setText("");
//        XWPFTableCell cellllll73 = rowIndexxxxx16.getCell(3);
//        cellllll73.setText("");
//        XWPFTableCell cellllll74 = rowIndexxxxx16.getCell(4);
//        cellllll74.setText("");
//        XWPFTableCell cellllll75 = rowIndexxxxx16.getCell(5);
//        cellllll75.setText("");
//        XWPFTableCell cellllll76 = rowIndexxxxx16.getCell(6);
//        cellllll76.setText("");
//        XWPFTableCell cellllll77 = rowIndexxxxx16.getCell(7);
//        cellllll77.setText("");
//        XWPFTableCell cellllll78 = rowIndexxxxx16.getCell(8);
//        cellllll78.setText("");
//
//        XWPFTableRow rowIndexxxxx17 = tablee4.getRow(8);
//        XWPFTableCell cellllll80 = rowIndexxxxx17.getCell(0);
//        cellllll80.setText("车间毛利率");
//        XWPFTableCell cellllll81 = rowIndexxxxx17.getCell(1);
//        cellllll81.setText("");
//        XWPFTableCell cellllll82 = rowIndexxxxx17.getCell(2);
//        cellllll82.setText("");
//        XWPFTableCell cellllll83 = rowIndexxxxx17.getCell(3);
//        cellllll83.setText("");
//        XWPFTableCell cellllll84 = rowIndexxxxx17.getCell(4);
//        cellllll84.setText("");
//        XWPFTableCell cellllll85 = rowIndexxxxx17.getCell(5);
//        cellllll85.setText("");
//        XWPFTableCell cellllll86 = rowIndexxxxx17.getCell(6);
//        cellllll86.setText("");
//        XWPFTableCell cellllll87 = rowIndexxxxx17.getCell(7);
//        cellllll87.setText("");
//        XWPFTableCell cellllll88 = rowIndexxxxx17.getCell(8);
//        cellllll88.setText("");

        fileInputStream.close();

        OutputStream output = new FileOutputStream(filePath);
        document.write(output);
        output.close();
    }

    public static void exportKpiToWord(OperationalVO vo, String filePath, String templetPath) throws IOException {
        FileInputStream fileInputStream = new FileInputStream(filePath);
        CustomXWPFDocument document = new CustomXWPFDocument(fileInputStream);

//        //创建document对象
//        XWPFDocument document = new XWPFDocument();

//        //添加标题
//        XWPFParagraph titleParagraph = document.createParagraph();
//        //设置段落居中
//        titleParagraph.setAlignment(ParagraphAlignment.CENTER);
//        XWPFRun titleParagraphRun = titleParagraph.createRun();
//        titleParagraphRun.setText(titleName);
////        titleParagraphRun.setColor("000000");
//        titleParagraphRun.setFontSize(20);


        //处理表达合并和数据填充

//        //合并列
//        mergeCellsVertically(table, 0, 0, 1);
//        mergeCellsVertically(table, 2, 0, 1);
//        mergeCellsVertically(table, column-1, 0, 1);
//
//        //合并行
//        for(int i=0;i<row-2;i++){
//            mergeCellsHorizontal(table, i, 0, 1);
//            mergeCellsHorizontal(table, i, 2, 4);
//        }
//
//        mergeCellsHorizontal(table, 0, 5, column-2);
//        mergeCellsHorizontal(table, row-2, 0, 4);
//        mergeCellsHorizontal(table, row-1, 0, 4);
//        mergeCellsHorizontal(table, row-1, 5, column-1);


        List<Object[]> obj = vo.getBodyShop();
        if (null != obj && obj.size() > 0) {
            for (Object[] a : obj) {
                FileInputStream streamHappy = new FileInputStream(templetPath + "/templet/happy.png");
                FileInputStream streamAlert = new FileInputStream(templetPath + "/templet/alert.png");
                //创建表格
                int row = 4;
                int column = 3;
                XWPFTable table = document.createTable(row, column);
                CTTblBorders borders = table.getCTTbl().getTblPr().addNewTblBorders();
                CTBorder hBorder = borders.addNewInsideH();
                hBorder.setVal(STBorder.NIL);  // 线条类型
                hBorder.setSz(new BigInteger("1")); // 线条大小
                hBorder.setColor("3A5FCD"); // 设置颜色8
                setTableWidth(table, "10000");

                CTBorder vBorder = borders.addNewInsideV();
                vBorder.setVal(STBorder.NIL);
                vBorder.setSz(new BigInteger("1"));
                vBorder.setColor("3A5FCD");

                CTBorder lBorder = borders.addNewLeft();
                lBorder.setVal(STBorder.Enum.forString("single"));
                lBorder.setSz(new BigInteger("1"));
                lBorder.setColor("3A5FCD");

                CTBorder rBorder = borders.addNewRight();
                rBorder.setVal(STBorder.Enum.forString("single"));
                rBorder.setSz(new BigInteger("1"));
                rBorder.setColor("3A5FCD");

                CTBorder tBorder = borders.addNewTop();
                tBorder.setVal(STBorder.Enum.forString("single"));
                tBorder.setSz(new BigInteger("1"));
                tBorder.setColor("3A5FCD");

                CTBorder bBorder = borders.addNewBottom();
                bBorder.setVal(STBorder.Enum.forString("single"));
                bBorder.setSz(new BigInteger("1"));
                bBorder.setColor("3A5FCD");

                mergeCellsHorizontal(table, 2, 0, 2);
                mergeCellsHorizontal(table, 3, 0, 2);

                //设置指定宽度
//                CTTbl ttbl = table.getCTTbl();
//                CTTblWidth infoTableWidth = table.getCTTbl().addNewTblPr().addNewTblW();
//                infoTableWidth.setType(STTblWidth.DXA);
//                infoTableWidth.setW(BigInteger.valueOf(9072));

//                CTTblGrid tblGrid = ttbl.addNewTblGrid();
//                int[] colWidths = new int[]{5000, 4500, 500};
//
//                for (int i : colWidths) {
//                    CTTblGridCol gridCol = tblGrid.addNewGridCol();
//                    gridCol.setW(new BigInteger(i + ""));
//
//                }


                //填充数据
                XWPFTableRow rowIndex = table.getRow(0);
                XWPFTableCell cell = rowIndex.getCell(0);
//                cell.setText(a[0].toString());
                cell.setColor("5082bf");
                XWPFParagraph p1 = cell.getParagraphs().get(0);
                XWPFRun r1 = p1.createRun();
                r1.setText(a[0].toString());
                r1.setColor("FFFFFF");
                r1.setBold(true);
                r1.setFontFamily("微软雅黑");
                r1.setFontSize(9);
                setCellText(cell, 5000, false, 0, "000000");

                XWPFTableCell cell10 = rowIndex.getCell(1);
//                cell.setText(a[0].toString());
                cell10.setColor("5082bf");
//                setCellText(cell10, a[2].toString(), 4000, true, 0, "FFFFFF");
                XWPFParagraph p10 = cell10.getParagraphs().get(0);
                XWPFRun r10 = p10.createRun();
                r10.setText(a[2].toString());
                r10.setColor("FFFFFF");
                r10.setBold(true);
                r10.setFontFamily("微软雅黑");
                r10.setFontSize(9);
                setCellText(cell10, 4500, false, 0, "000000");


                XWPFTableCell cell1 = rowIndex.getCell(2);
//                cell1.setText(a[5].toString());
                cell1.setColor("5082bf");
                XWPFParagraph pargraph = cell1.getParagraphs().get(0);
                XWPFRun run = pargraph.createRun();

                if ("笑脸".equals(a[5].toString())) {
                    try {
                        run.addPicture(streamHappy, CustomXWPFDocument.PICTURE_TYPE_PNG, "happy.png", Units.toEMU(20), Units.toEMU(20));
//                        int ind = document.addPicture(streamHappy,CustomXWPFDocument.PICTURE_TYPE_PNG);
//                        document.createPicture(ind, 50 , 50,pargraph);
                    } catch (Exception e) {
                        e.printStackTrace();
                    }
                } else {
                    try {
                        run.addPicture(streamAlert, CustomXWPFDocument.PICTURE_TYPE_PNG, "alert.png", Units.toEMU(20), Units.toEMU(20));
//                        int ind = document.addPicture(streamAlert,CustomXWPFDocument.PICTURE_TYPE_PNG);
//                        document.createPicture(ind, 50 , 50,pargraph);
                    } catch (Exception e) {
                        e.printStackTrace();
                    }
                }
                setCellText(cell1, 500, false, 0, "000000");

                XWPFTableRow rowIndex1 = table.getRow(1);
                XWPFTableCell cell21 = rowIndex1.getCell(0);
//                cell21.setColor("5082bf");
                XWPFParagraph pargraph1 = cell21.getParagraphs().get(0);
                XWPFRun run1 = pargraph1.createRun();

                if (null != a[6] && StringUtils.isNotEmpty(a[6].toString())) {
                    System.out.println(a[6]);
//                    URL url = new URL("http://vstar.oss-cn-hangzhou.aliyuncs.com/" + a[6].toString() + "?x-oss-process=image/format,jpg/quality,Q_100/resize,m_fill,h_300,w_420");
                    URL url = new URL("http://vstar.oss-cn-hangzhou.aliyuncs.com/" + a[6].toString() + "?x-oss-process=image/quality,Q_100/resize,m_fill,h_300,w_420/format,jpg/auto-orient,0");
                    HttpURLConnection con = (HttpURLConnection) url.openConnection();//打开链接方式
                    con.setRequestMethod("GET");//以GET方式请求连接
                    con.setConnectTimeout(5 * 1000);//设置连接时间为5秒
                    try {
                        InputStream is = con.getInputStream();//输入流获取图片
                        run1.addPicture(is, CustomXWPFDocument.PICTURE_TYPE_PNG, "happy.png", Units.toEMU(160), Units.toEMU(110));
//                        int ind = document.addPicture(streamHappy,CustomXWPFDocument.PICTURE_TYPE_PNG);
//                        document.createPicture(ind, 50 , 50,pargraph);
                    } catch (Exception e) {
                        e.printStackTrace();
                    }
                } else {
                    FileInputStream streamPhoto = new FileInputStream(templetPath + "/templet/akzo.png");
                    try {
                        run1.addPicture(streamPhoto, CustomXWPFDocument.PICTURE_TYPE_PNG, "happy.png", Units.toEMU(160), Units.toEMU(110));
                    } catch (Exception e) {
                        e.printStackTrace();
                    }
                }
                setCellText(cell21, 5000, false, 0, "000000");
//                FileInputStream streamPhoto = new FileInputStream("http://vstar.oss-cn-hangzhou.aliyuncs.com/" + a[6].toString());


                XWPFTableCell cell2 = rowIndex1.getCell(1);
//                cell2.setText(a[4].toString());

                XWPFParagraph p2 = cell2.getParagraphs().get(0);
                XWPFRun r2 = p2.createRun();
                r2.setText(a[4].toString());
//                r2.setColor("FFFFFF");
//                r2.setBold(true);
                r2.setFontFamily("微软雅黑");
                r2.setFontSize(9);
                setCellText(cell2, 4500, false, 0, "000000");
                XWPFTableCell cell3 = rowIndex1.getCell(2);
                cell3.setText("");
                setCellText(cell3, 500, false, 0, "000000");

                XWPFTableRow rowIndex2 = table.getRow(2);
                XWPFTableCell cell4 = rowIndex2.getCell(0);
                cell4.setColor("5082bf");
                XWPFParagraph p4 = cell4.getParagraphs().get(0);
                XWPFRun r4 = p4.createRun();
                r4.setText("建议");
                r4.setColor("FFFFFF");
                r4.setBold(true);
                r4.setFontFamily("微软雅黑");
                r4.setFontSize(9);
                setCellText(cell4, 5000, false, 0, "000000");
                XWPFTableCell cell5 = rowIndex2.getCell(1);
                cell5.setText("");
                cell5.setColor("5082bf");
                setCellText(cell5, 4500, false, 0, "000000");
                XWPFTableCell cell50 = rowIndex2.getCell(2);
                cell50.setText("");
                cell50.setColor("5082bf");
                setCellText(cell50, 500, false, 0, "000000");

                XWPFTableRow rowIndex3 = table.getRow(3);
                XWPFTableCell cell6 = rowIndex3.getCell(0);

                XWPFParagraph p6 = cell6.getParagraphs().get(0);
                XWPFRun r6 = p6.createRun();
                r6.setText(a[3].toString());
                r6.setFontFamily("微软雅黑");
                r6.setFontSize(9);

//                cell6.setText(a[3].toString());
                setCellText(cell6, 5000, false, 0, "000000");
                XWPFTableCell cell7 = rowIndex3.getCell(1);
                cell7.setText("");
                setCellText(cell7, 4500, false, 0, "000000");
                XWPFTableCell cell8 = rowIndex3.getCell(2);
                cell8.setText("");
                setCellText(cell8, 500, false, 0, "000000");

                //添加标题
                XWPFParagraph titleParagraphh1 = document.createParagraph();
                //设置段落居中
                titleParagraphh1.setAlignment(ParagraphAlignment.LEFT);
                XWPFRun titleParagraphRunh1 = titleParagraphh1.createRun();
                titleParagraphRunh1.setText("");
                titleParagraphRunh1.setFontFamily("微软雅黑");
                streamHappy.close();
                streamAlert.close();
            }
        }


        //添加标题
        XWPFParagraph titleParagraph = document.createParagraph();
        //设置段落居中
        titleParagraph.setAlignment(ParagraphAlignment.CENTER);
        XWPFRun titleParagraphRun = titleParagraph.createRun();
        titleParagraphRun.setText("维修站产能状况");
//        titleParagraphRun.setColor("000000");
        titleParagraphRun.setFontSize(20);
        titleParagraphRun.setFontFamily("微软雅黑");

        //添加标题
        XWPFParagraph titleParagraph1 = document.createParagraph();
        //设置段落居中
        titleParagraph1.setAlignment(ParagraphAlignment.LEFT);
        XWPFRun titleParagraphRun1 = titleParagraph1.createRun();
        titleParagraphRun1.setText("填写项");
//        titleParagraphRun.setColor("000000");
        titleParagraphRun1.setFontSize(17);
        titleParagraphRun1.setFontFamily("微软雅黑");
        //创建表格
        int row1 = 10;
        int column1 = 4;
        XWPFTable table1 = document.createTable(row1, column1);
        CTTblBorders borders = table1.getCTTbl().getTblPr().addNewTblBorders();
        CTBorder hBorder = borders.addNewInsideH();
        hBorder.setVal(STBorder.Enum.forString("single"));  // 线条类型
        hBorder.setSz(new BigInteger("1")); // 线条大小
        hBorder.setColor("FFFFFF"); // 设置颜色8

        CTBorder vBorder = borders.addNewInsideV();
        vBorder.setVal(STBorder.Enum.forString("single"));
        vBorder.setSz(new BigInteger("1"));
        vBorder.setColor("FFFFFF");

        CTBorder lBorder = borders.addNewLeft();
        lBorder.setVal(STBorder.NIL);
        lBorder.setSz(new BigInteger("1"));
        lBorder.setColor("3A5FCD");

        CTBorder rBorder = borders.addNewRight();
        rBorder.setVal(STBorder.NIL);
        rBorder.setSz(new BigInteger("1"));
        rBorder.setColor("3A5FCD");

        CTBorder tBorder = borders.addNewTop();
        tBorder.setVal(STBorder.NIL);
        tBorder.setSz(new BigInteger("1"));
        tBorder.setColor("3A5FCD");

        CTBorder bBorder = borders.addNewBottom();
        bBorder.setVal(STBorder.NIL);
        bBorder.setSz(new BigInteger("1"));
        bBorder.setColor("3A5FCD");
        setTableWidth(table1, "10000");
        //填充数据
        XWPFTableRow rowIndex10 = table1.getRow(0);
        XWPFTableCell cell10 = rowIndex10.getCell(0);
        cell10.setText("");
        cell10.setColor("5082bf");
        setCellStyle(cell10, "项目", true, "FFFFFF", 11);
        XWPFTableCell cell11 = rowIndex10.getCell(1);
        cell11.setText("");
        cell11.setColor("5082bf");
        setCellStyle(cell11, "行业参考值（范围）", true, "FFFFFF", 11);
        XWPFTableCell cell12 = rowIndex10.getCell(2);
        cell12.setText("");
        cell12.setColor("5082bf");
        setCellStyle(cell12, "偏差诊断及建议", true, "FFFFFF", 11);
        XWPFTableCell cell13 = rowIndex10.getCell(3);
        cell13.setText("");
        cell13.setColor("5082bf");
        setCellStyle(cell13, "AkzoNobel解决方案", true, "FFFFFF", 11);


        XWPFTableRow rowIndex11 = table1.getRow(1);
        XWPFTableCell cell20 = rowIndex11.getCell(0);
        cell20.setText("");
        cell20.setColor("5082bf");
        setCellStyle(cell20, "月喷漆产值（元）", true, "FFFFFF", 11);
        XWPFTableCell cell21 = rowIndex11.getCell(1);
        cell21.setColor("b8cce4");
        setCellStyle(cell21, "", false, "000000", 10);
        XWPFTableCell cell22 = rowIndex11.getCell(2);
        cell22.setColor("b8cce4");
        setCellStyle(cell22, "", false, "000000", 10);
        XWPFTableCell cell23 = rowIndex11.getCell(3);
        cell23.setColor("b8cce4");
        setCellStyle(cell23, "", false, "000000", 10);

        XWPFTableRow rowIndex12 = table1.getRow(2);
        XWPFTableCell cell30 = rowIndex12.getCell(0);
        cell30.setText("");
        cell30.setColor("5082bf");
        setCellStyle(cell30, "喷漆维修台次", true, "FFFFFF", 11);
        XWPFTableCell cell31 = rowIndex12.getCell(1);
        cell31.setColor("dbe5f1");
        setCellStyle(cell31, "", false, "000000", 10);
        XWPFTableCell cell32 = rowIndex12.getCell(2);
        cell32.setColor("dbe5f1");
        setCellStyle(cell32, "", false, "000000", 10);
        XWPFTableCell cell33 = rowIndex12.getCell(3);
        cell33.setColor("dbe5f1");
        setCellStyle(cell33, "", false, "000000", 10);

        XWPFTableRow rowIndex13 = table1.getRow(3);
        XWPFTableCell cell40 = rowIndex13.getCell(0);
        cell40.setText("");
        cell40.setColor("5082bf");
        setCellStyle(cell40, "车间喷漆工人数", true, "FFFFFF", 11);
        XWPFTableCell cell41 = rowIndex13.getCell(1);
        cell41.setColor("b8cce4");
        setCellStyle(cell41, "", false, "000000", 10);
        XWPFTableCell cell42 = rowIndex13.getCell(2);
        cell42.setColor("b8cce4");
        setCellStyle(cell42, "", false, "000000", 10);
        XWPFTableCell cell43 = rowIndex13.getCell(3);
        cell43.setColor("b8cce4");
        setCellStyle(cell43, "", false, "000000", 10);

        XWPFTableRow rowIndex14 = table1.getRow(4);
        XWPFTableCell cell50 = rowIndex14.getCell(0);
        cell50.setText("");
        cell50.setColor("5082bf");
        setCellStyle(cell50, "车间喷涂工位数（不含烤房）", true, "FFFFFF", 11);
        XWPFTableCell cell51 = rowIndex14.getCell(1);
        cell51.setColor("dbe5f1");
        setCellStyle(cell51, "", false, "000000", 10);
        XWPFTableCell cell52 = rowIndex14.getCell(2);
        cell52.setColor("dbe5f1");
        setCellStyle(cell52, "", false, "000000", 10);
        XWPFTableCell cell53 = rowIndex14.getCell(3);
        cell53.setColor("dbe5f1");
        setCellStyle(cell53, "", false, "000000", 10);

        XWPFTableRow rowIndex15 = table1.getRow(5);
        XWPFTableCell cell60 = rowIndex15.getCell(0);
        cell60.setText("");
        cell60.setColor("5082bf");
        setCellStyle(cell60, "平均单面喷漆收费", true, "FFFFFF", 11);
        XWPFTableCell cell61 = rowIndex15.getCell(1);
        cell61.setColor("b8cce4");
        setCellStyle(cell61, "", false, "000000", 10);
        XWPFTableCell cell62 = rowIndex15.getCell(2);
        cell62.setColor("b8cce4");
        setCellStyle(cell62, "", false, "000000", 10);
        XWPFTableCell cell63 = rowIndex15.getCell(3);
        cell63.setColor("b8cce4");
        setCellStyle(cell63, "", false, "000000", 10);

        XWPFTableRow rowIndex16 = table1.getRow(6);
        XWPFTableCell cell70 = rowIndex16.getCell(0);
        cell70.setText("");
        cell70.setColor("5082bf");
        setCellStyle(cell70, "油漆采购额（不含税）", true, "FFFFFF", 11);
        XWPFTableCell cell71 = rowIndex16.getCell(1);
        cell71.setColor("dbe5f1");
        setCellStyle(cell71, "", false, "000000", 10);
        XWPFTableCell cell72 = rowIndex16.getCell(2);
        cell72.setColor("dbe5f1");
        setCellStyle(cell72, "", false, "000000", 10);
        XWPFTableCell cell73 = rowIndex16.getCell(3);
        cell73.setColor("dbe5f1");
        setCellStyle(cell73, "", false, "000000", 10);

        XWPFTableRow rowIndex17 = table1.getRow(7);
        XWPFTableCell cell80 = rowIndex17.getCell(0);
        cell80.setText("");
        cell80.setColor("5082bf");
        setCellStyle(cell80, "月漆工工资（元）", true, "FFFFFF", 11);
        XWPFTableCell cell81 = rowIndex17.getCell(1);
        cell81.setColor("b8cce4");
        setCellStyle(cell81, "", false, "000000", 10);
        XWPFTableCell cell82 = rowIndex17.getCell(2);
        cell82.setColor("b8cce4");
        setCellStyle(cell82, "", false, "000000", 10);
        XWPFTableCell cell83 = rowIndex17.getCell(3);
        cell83.setColor("b8cce4");
        setCellStyle(cell83, "", false, "000000", 10);

        XWPFTableRow rowIndex18 = table1.getRow(8);
        XWPFTableCell cell90 = rowIndex18.getCell(0);
        cell90.setText("");
        cell90.setColor("5082bf");
        setCellStyle(cell90, "烤房数量", true, "FFFFFF", 11);
        XWPFTableCell cell91 = rowIndex18.getCell(1);
        cell91.setColor("dbe5f1");
        setCellStyle(cell91, "", false, "000000", 10);
        XWPFTableCell cell92 = rowIndex18.getCell(2);
        cell92.setColor("dbe5f1");
        setCellStyle(cell92, "", false, "000000", 10);
        XWPFTableCell cell93 = rowIndex18.getCell(3);
        cell93.setColor("dbe5f1");
        setCellStyle(cell93, "", false, "000000", 10);

        XWPFTableRow rowIndex19 = table1.getRow(9);
        XWPFTableCell cell100 = rowIndex19.getCell(0);
        cell100.setText("");
        cell100.setColor("5082bf");
        setCellStyle(cell100, "返工台次", true, "FFFFFF", 11);
        XWPFTableCell cell101 = rowIndex19.getCell(1);
        cell101.setColor("b8cce4");
        setCellStyle(cell101, "", false, "000000", 10);
        XWPFTableCell cell102 = rowIndex19.getCell(2);
        cell102.setColor("b8cce4");
        setCellStyle(cell102, "", false, "000000", 10);
        XWPFTableCell cell103 = rowIndex19.getCell(3);
        cell103.setColor("b8cce4");
        setCellStyle(cell103, "", false, "000000", 10);


        //添加标题
        XWPFParagraph titleParagraphh1 = document.createParagraph();
        //设置段落居中
        titleParagraphh1.setAlignment(ParagraphAlignment.LEFT);
        XWPFRun titleParagraphRunh1 = titleParagraphh1.createRun();
        titleParagraphRunh1.setText("");
//        titleParagraphRun.setColor("000000");
        titleParagraphRunh1.setFontSize(17);
        titleParagraphRunh1.setFontFamily("微软雅黑");

        //创建表格
        int roww1 = 10;
        int columnn1 = 9;
        XWPFTable tablee1 = document.createTable(roww1, columnn1);
        setTableStyle(tablee1);
        setTableWidth(tablee1, "10000");
        //填充数据
        XWPFTableRow rowIndexx10 = tablee1.getRow(0);
        XWPFTableCell celll10 = rowIndexx10.getCell(0);
        celll10.setText("");
        celll10.setColor("5082bf");
        setCellStyle(celll10, "项目", true, "FFFFFF", 11);
        XWPFTableCell celll11 = rowIndexx10.getCell(1);
        celll11.setText("");
        celll11.setColor("5082bf");
        setCellStyle(celll11, "改善前3个月", true, "FFFFFF", 11);
        XWPFTableCell celll12 = rowIndexx10.getCell(2);
        celll12.setText("");
        celll12.setColor("5082bf");
        setCellStyle(celll12, "改善前2个月", true, "FFFFFF", 11);
        XWPFTableCell celll13 = rowIndexx10.getCell(3);
        celll13.setText("");
        celll13.setColor("5082bf");
        setCellStyle(celll13, "改善前1个月", true, "FFFFFF", 11);
        XWPFTableCell celll14 = rowIndexx10.getCell(4);
        celll14.setText("");
        celll14.setColor("5082bf");
        setCellStyle(celll14, "改善当月", true, "FFFFFF", 11);
        XWPFTableCell celll15 = rowIndexx10.getCell(5);
        celll15.setText("");
        celll15.setColor("5082bf");
        setCellStyle(celll15, "改善后1个月", true, "FFFFFF", 11);
        XWPFTableCell celll16 = rowIndexx10.getCell(6);
        celll16.setText("");
        celll16.setColor("5082bf");
        setCellStyle(celll16, "改善后2个月", true, "FFFFFF", 11);
        XWPFTableCell celll17 = rowIndexx10.getCell(7);
        celll17.setText("");
        celll17.setColor("5082bf");
        setCellStyle(celll17, "改善后3个月", true, "FFFFFF", 11);
        XWPFTableCell celll18 = rowIndexx10.getCell(8);
        celll18.setText("");
        celll18.setColor("5082bf");
        setCellStyle(celll18, "平均值", true, "FFFFFF", 11);


        List<Object[]> list1 = vo.getOperationalDataAnalysis();

        Object[] o1 = list1.get(0);
        Object[] o2 = list1.get(1);
        Object[] o3 = list1.get(2);
        Object[] o4 = list1.get(3);
        Object[] o5 = list1.get(4);
        Object[] o6 = list1.get(5);
        Object[] o7 = list1.get(6);
        Object[] o8 = list1.get(7);

        XWPFTableRow rowIndexx11 = tablee1.getRow(1);
        XWPFTableCell celll20 = rowIndexx11.getCell(0);
        celll20.setText("");
        celll20.setColor("5082bf");
        setCellStyle(celll20, "月喷漆产值（元）", true, "FFFFFF", 11);
        XWPFTableCell celll21 = rowIndexx11.getCell(1);
        celll21.setText("");
        celll21.setColor("b8cce4");
        setCellStyle(celll21, o1[1].toString(), false, "000000", 10);
        XWPFTableCell celll22 = rowIndexx11.getCell(2);
        celll22.setText("");
        celll22.setColor("b8cce4");
        setCellStyle(celll22, o2[1].toString(), false, "000000", 10);
        XWPFTableCell celll23 = rowIndexx11.getCell(3);
        celll23.setText("");
        celll23.setColor("b8cce4");
        setCellStyle(celll23, o3[1].toString(), false, "000000", 10);
        XWPFTableCell celll24 = rowIndexx11.getCell(4);
        celll24.setText("");
        celll24.setColor("b8cce4");
        setCellStyle(celll24, o4[1].toString(), false, "000000", 10);
        XWPFTableCell celll25 = rowIndexx11.getCell(5);
        celll25.setText("");
        celll25.setColor("b8cce4");
        setCellStyle(celll25, o5[1].toString(), false, "000000", 10);
        XWPFTableCell celll26 = rowIndexx11.getCell(6);
        celll26.setText("");
        celll26.setColor("b8cce4");
        setCellStyle(celll26, o6[1].toString(), false, "000000", 10);
        XWPFTableCell celll27 = rowIndexx11.getCell(7);
        celll27.setText("");
        celll27.setColor("b8cce4");
        setCellStyle(celll27, o7[1].toString(), false, "000000", 10);
        XWPFTableCell celll28 = rowIndexx11.getCell(8);
        celll28.setText("");
        celll28.setColor("b8cce4");
        setCellStyle(celll28, o8[1].toString(), false, "000000", 10);

        XWPFTableRow rowIndexx12 = tablee1.getRow(2);
        XWPFTableCell celll30 = rowIndexx12.getCell(0);
        celll30.setText("");
        celll30.setColor("5082bf");
        setCellStyle(celll30, "喷漆维修台次", true, "FFFFFF", 11);
        XWPFTableCell celll31 = rowIndexx12.getCell(1);
        celll31.setText("");
        celll31.setColor("dbe5f1");
        setCellStyle(celll31, o1[2].toString(), false, "000000", 10);
        XWPFTableCell celll32 = rowIndexx12.getCell(2);
        celll32.setText("");
        celll32.setColor("dbe5f1");
        setCellStyle(celll32, o2[2].toString(), false, "000000", 10);
        XWPFTableCell celll33 = rowIndexx12.getCell(3);
        celll33.setText("");
        celll33.setColor("dbe5f1");
        setCellStyle(celll33, o3[2].toString(), false, "000000", 10);
        XWPFTableCell celll34 = rowIndexx12.getCell(4);
        celll34.setText("");
        celll34.setColor("dbe5f1");
        setCellStyle(celll34, o4[2].toString(), false, "000000", 10);
        XWPFTableCell celll35 = rowIndexx12.getCell(5);
        celll35.setText("");
        celll35.setColor("dbe5f1");
        setCellStyle(celll35, o5[2].toString(), false, "000000", 10);
        XWPFTableCell celll36 = rowIndexx12.getCell(6);
        celll36.setText("");
        celll36.setColor("dbe5f1");
        setCellStyle(celll36, o6[2].toString(), false, "000000", 10);
        XWPFTableCell celll37 = rowIndexx12.getCell(7);
        celll37.setText("");
        celll37.setColor("dbe5f1");
        setCellStyle(celll37, o7[2].toString(), false, "000000", 10);
        XWPFTableCell celll38 = rowIndexx12.getCell(8);
        celll38.setText("");
        celll38.setColor("dbe5f1");
        setCellStyle(celll38, o8[2].toString(), false, "000000", 10);

        XWPFTableRow rowIndexx13 = tablee1.getRow(3);
        XWPFTableCell celll40 = rowIndexx13.getCell(0);
        celll40.setText("");
        celll40.setColor("5082bf");
        setCellStyle(celll40, "车间喷漆工人数", true, "FFFFFF", 11);
        XWPFTableCell celll41 = rowIndexx13.getCell(1);
        celll41.setText("");
        celll41.setColor("b8cce4");
        setCellStyle(celll41, o1[3].toString(), false, "000000", 10);
        XWPFTableCell celll42 = rowIndexx13.getCell(2);
        celll42.setText("");
        celll42.setColor("b8cce4");
        setCellStyle(celll42, o2[3].toString(), false, "000000", 10);
        XWPFTableCell celll43 = rowIndexx13.getCell(3);
        celll43.setText("");
        celll43.setColor("b8cce4");
        setCellStyle(celll43, o3[3].toString(), false, "000000", 10);
        XWPFTableCell celll44 = rowIndexx13.getCell(4);
        celll44.setText("");
        celll44.setColor("b8cce4");
        setCellStyle(celll44, o4[3].toString(), false, "000000", 10);
        XWPFTableCell celll45 = rowIndexx13.getCell(5);
        celll45.setText("");
        celll45.setColor("b8cce4");
        setCellStyle(celll45, o5[3].toString(), false, "000000", 10);
        XWPFTableCell celll46 = rowIndexx13.getCell(6);
        celll46.setText("");
        celll46.setColor("b8cce4");
        setCellStyle(celll46, o6[3].toString(), false, "000000", 10);
        XWPFTableCell celll47 = rowIndexx13.getCell(7);
        celll47.setText("");
        celll47.setColor("b8cce4");
        setCellStyle(celll47, o7[3].toString(), false, "000000", 10);
        XWPFTableCell celll48 = rowIndexx13.getCell(8);
        celll48.setText("");
        celll48.setColor("b8cce4");
        setCellStyle(celll48, o8[3].toString(), false, "000000", 10);

        XWPFTableRow rowIndexx14 = tablee1.getRow(4);
        XWPFTableCell celll50 = rowIndexx14.getCell(0);
        celll50.setText("");
        celll50.setColor("5082bf");
        setCellStyle(celll50, "车间喷涂工位数（不含烤房）", true, "FFFFFF", 11);
        XWPFTableCell celll51 = rowIndexx14.getCell(1);
        celll51.setText("");
        celll51.setColor("dbe5f1");
        setCellStyle(celll51, o1[4].toString(), false, "000000", 10);
        XWPFTableCell celll52 = rowIndexx14.getCell(2);
        celll52.setText("");
        celll52.setColor("dbe5f1");
        setCellStyle(celll52, o2[4].toString(), false, "000000", 10);
        XWPFTableCell celll53 = rowIndexx14.getCell(3);
        celll53.setText("");
        celll53.setColor("dbe5f1");
        setCellStyle(celll53, o3[4].toString(), false, "000000", 10);
        XWPFTableCell celll54 = rowIndexx14.getCell(4);
        celll54.setText("");
        celll54.setColor("dbe5f1");
        setCellStyle(celll54, o4[4].toString(), false, "000000", 10);
        XWPFTableCell celll55 = rowIndexx14.getCell(5);
        celll55.setText("");
        celll55.setColor("dbe5f1");
        setCellStyle(celll55, o5[4].toString(), false, "000000", 10);
        XWPFTableCell celll56 = rowIndexx14.getCell(6);
        celll56.setText("");
        celll56.setColor("dbe5f1");
        setCellStyle(celll56, o6[4].toString(), false, "000000", 10);
        XWPFTableCell celll57 = rowIndexx14.getCell(7);
        celll57.setText("");
        celll57.setColor("dbe5f1");
        setCellStyle(celll57, o7[4].toString(), false, "000000", 10);
        XWPFTableCell celll58 = rowIndexx14.getCell(8);
        celll58.setText("");
        celll58.setColor("dbe5f1");
        setCellStyle(celll58, o8[4].toString(), false, "000000", 10);

        XWPFTableRow rowIndexx15 = tablee1.getRow(5);
        XWPFTableCell celll60 = rowIndexx15.getCell(0);
        celll60.setText("");
        celll60.setColor("5082bf");
        setCellStyle(celll60, "平均单面喷漆收费", true, "FFFFFF", 11);
        XWPFTableCell celll61 = rowIndexx15.getCell(1);
        celll61.setText("");
        celll61.setColor("b8cce4");
        setCellStyle(celll61, o1[5].toString(), false, "000000", 10);
        XWPFTableCell celll62 = rowIndexx15.getCell(2);
        celll62.setText("");
        celll62.setColor("b8cce4");
        setCellStyle(celll62, o2[5].toString(), false, "000000", 10);
        XWPFTableCell celll63 = rowIndexx15.getCell(3);
        celll63.setText("");
        celll63.setColor("b8cce4");
        setCellStyle(celll63, o3[5].toString(), false, "000000", 10);
        XWPFTableCell celll64 = rowIndexx15.getCell(4);
        celll64.setText("");
        celll64.setColor("b8cce4");
        setCellStyle(celll64, o4[5].toString(), false, "000000", 10);
        XWPFTableCell celll65 = rowIndexx15.getCell(5);
        celll65.setText("");
        celll65.setColor("b8cce4");
        setCellStyle(celll65, o5[5].toString(), false, "000000", 10);
        XWPFTableCell celll66 = rowIndexx15.getCell(6);
        celll66.setText("");
        celll66.setColor("b8cce4");
        setCellStyle(celll66, o6[5].toString(), false, "000000", 10);
        XWPFTableCell celll67 = rowIndexx15.getCell(7);
        celll67.setText("");
        celll67.setColor("b8cce4");
        setCellStyle(celll67, o7[5].toString(), false, "000000", 10);
        XWPFTableCell celll68 = rowIndexx15.getCell(8);
        celll68.setText("");
        celll68.setColor("b8cce4");
        setCellStyle(celll68, o8[5].toString(), false, "000000", 10);

        XWPFTableRow rowIndexx16 = tablee1.getRow(6);
        XWPFTableCell celll70 = rowIndexx16.getCell(0);
        celll70.setText("");
        celll70.setColor("5082bf");
        setCellStyle(celll70, "油漆采购额（不含税）", true, "FFFFFF", 11);
        XWPFTableCell celll71 = rowIndexx16.getCell(1);
        celll71.setText("");
        celll71.setColor("dbe5f1");
        setCellStyle(celll71, o1[6].toString(), false, "000000", 10);
        XWPFTableCell celll72 = rowIndexx16.getCell(2);
        celll72.setText("");
        celll72.setColor("dbe5f1");
        setCellStyle(celll72, o2[6].toString(), false, "000000", 10);
        XWPFTableCell celll73 = rowIndexx16.getCell(3);
        celll73.setText("");
        celll73.setColor("dbe5f1");
        setCellStyle(celll73, o3[6].toString(), false, "000000", 10);
        XWPFTableCell celll74 = rowIndexx16.getCell(4);
        celll74.setText("");
        celll74.setColor("dbe5f1");
        setCellStyle(celll74, o4[6].toString(), false, "000000", 10);
        XWPFTableCell celll75 = rowIndexx16.getCell(5);
        celll75.setText("");
        celll75.setColor("dbe5f1");
        setCellStyle(celll75, o5[6].toString(), false, "000000", 10);
        XWPFTableCell celll76 = rowIndexx16.getCell(6);
        celll76.setText("");
        celll76.setColor("dbe5f1");
        setCellStyle(celll76, o6[6].toString(), false, "000000", 10);
        XWPFTableCell celll77 = rowIndexx16.getCell(7);
        celll77.setText("");
        celll77.setColor("dbe5f1");
        setCellStyle(celll77, o7[6].toString(), false, "000000", 10);
        XWPFTableCell celll78 = rowIndexx16.getCell(8);
        celll78.setText("");
        celll78.setColor("dbe5f1");
        setCellStyle(celll78, o8[6].toString(), false, "000000", 10);

        XWPFTableRow rowIndexx17 = tablee1.getRow(7);
        XWPFTableCell celll80 = rowIndexx17.getCell(0);
        celll80.setText("");
        celll80.setColor("5082bf");
        setCellStyle(celll80, "月漆工工资（元）", true, "FFFFFF", 11);
        XWPFTableCell celll81 = rowIndexx17.getCell(1);
        celll81.setText("");
        celll81.setColor("b8cce4");
        setCellStyle(celll81, o1[7].toString(), false, "000000", 10);
        XWPFTableCell celll82 = rowIndexx17.getCell(2);
        celll82.setText("");
        celll82.setColor("b8cce4");
        setCellStyle(celll82, o2[7].toString(), false, "000000", 10);
        XWPFTableCell celll83 = rowIndexx17.getCell(3);
        celll83.setText("");
        celll83.setColor("b8cce4");
        setCellStyle(celll83, o3[7].toString(), false, "000000", 10);
        XWPFTableCell celll84 = rowIndexx17.getCell(4);
        celll84.setText("");
        celll84.setColor("b8cce4");
        setCellStyle(celll84, o4[7].toString(), false, "000000", 10);
        XWPFTableCell celll85 = rowIndexx17.getCell(5);
        celll85.setText("");
        celll85.setColor("b8cce4");
        setCellStyle(celll85, o5[7].toString(), false, "000000", 10);
        XWPFTableCell celll86 = rowIndexx17.getCell(6);
        celll86.setText("");
        celll86.setColor("b8cce4");
        setCellStyle(celll86, o6[7].toString(), false, "000000", 10);
        XWPFTableCell celll87 = rowIndexx17.getCell(7);
        celll87.setText("");
        celll87.setColor("b8cce4");
        setCellStyle(celll87, o7[7].toString(), false, "000000", 10);
        XWPFTableCell celll88 = rowIndexx17.getCell(8);
        celll88.setText("");
        celll88.setColor("b8cce4");
        setCellStyle(celll88, o8[7].toString(), false, "000000", 10);

        XWPFTableRow rowIndexx18 = tablee1.getRow(8);
        XWPFTableCell celll90 = rowIndexx18.getCell(0);
        celll90.setText("");
        celll90.setColor("5082bf");
        setCellStyle(celll90, "烤房数量", true, "FFFFFF", 11);
        XWPFTableCell celll91 = rowIndexx18.getCell(1);
        celll91.setText("");
        celll91.setColor("dbe5f1");
        setCellStyle(celll91, o1[8].toString(), false, "000000", 10);
        XWPFTableCell celll92 = rowIndexx18.getCell(2);
        celll92.setText("");
        celll92.setColor("dbe5f1");
        setCellStyle(celll92, o2[8].toString(), false, "000000", 10);
        XWPFTableCell celll93 = rowIndexx18.getCell(3);
        celll93.setText("");
        celll93.setColor("dbe5f1");
        setCellStyle(celll93, o3[8].toString(), false, "000000", 10);
        XWPFTableCell celll94 = rowIndexx18.getCell(4);
        celll94.setText("");
        celll94.setColor("dbe5f1");
        setCellStyle(celll94, o4[8].toString(), false, "000000", 10);
        XWPFTableCell celll95 = rowIndexx18.getCell(5);
        celll95.setText("");
        celll95.setColor("dbe5f1");
        setCellStyle(celll95, o5[8].toString(), false, "000000", 10);
        XWPFTableCell celll96 = rowIndexx18.getCell(6);
        celll96.setText("");
        celll96.setColor("dbe5f1");
        setCellStyle(celll96, o6[8].toString(), false, "000000", 10);
        XWPFTableCell celll97 = rowIndexx18.getCell(7);
        celll97.setText("");
        celll97.setColor("dbe5f1");
        setCellStyle(celll97, o7[8].toString(), false, "000000", 10);
        XWPFTableCell celll98 = rowIndexx18.getCell(8);
        celll98.setText("");
        celll98.setColor("dbe5f1");
        setCellStyle(celll98, o8[8].toString(), false, "000000", 10);

        XWPFTableRow rowIndexx19 = tablee1.getRow(9);
        XWPFTableCell celll100 = rowIndexx19.getCell(0);
        celll100.setText("");
        celll100.setColor("5082bf");
        setCellStyle(celll100, "返工台次", true, "FFFFFF", 11);
        XWPFTableCell celll101 = rowIndexx19.getCell(1);
        celll101.setText("");
        celll101.setColor("b8cce4");
        setCellStyle(celll101, o1[9].toString(), false, "000000", 10);
        XWPFTableCell celll102 = rowIndexx19.getCell(2);
        celll102.setText("");
        celll102.setColor("b8cce4");
        setCellStyle(celll102, o2[9].toString(), false, "000000", 10);
        XWPFTableCell celll103 = rowIndexx19.getCell(3);
        celll103.setText("");
        celll103.setColor("b8cce4");
        setCellStyle(celll103, o3[9].toString(), false, "000000", 10);
        XWPFTableCell celll104 = rowIndexx19.getCell(4);
        celll104.setText("");
        celll104.setColor("b8cce4");
        setCellStyle(celll104, o4[9].toString(), false, "000000", 10);
        XWPFTableCell celll105 = rowIndexx19.getCell(5);
        celll105.setText("");
        celll105.setColor("b8cce4");
        setCellStyle(celll105, o5[9].toString(), false, "000000", 10);
        XWPFTableCell celll106 = rowIndexx19.getCell(6);
        celll106.setText("");
        celll106.setColor("b8cce4");
        setCellStyle(celll106, o6[9].toString(), false, "000000", 10);
        XWPFTableCell celll107 = rowIndexx19.getCell(7);
        celll107.setText("");
        celll107.setColor("b8cce4");
        setCellStyle(celll107, o7[9].toString(), false, "000000", 10);
        XWPFTableCell celll108 = rowIndexx19.getCell(8);
        celll108.setText("");
        celll108.setColor("b8cce4");
        setCellStyle(celll108, o8[9].toString(), false, "000000", 10);


        //添加标题
        XWPFParagraph titleParagraph2 = document.createParagraph();
        //设置段落居中
        titleParagraph2.setAlignment(ParagraphAlignment.LEFT);
        XWPFRun titleParagraphRun2 = titleParagraph2.createRun();
        titleParagraphRun2.setText("单元运营一览");
//        titleParagraphRun.setColor("000000");
        titleParagraphRun2.setFontSize(17);
        titleParagraphRun2.setFontFamily("微软雅黑");
        //创建表格 单元运营一览
        int row2 = 10;
        int column2 = 4;
        XWPFTable table2 = document.createTable(row2, column2);
        setTableStyle(table2);
        setTableWidth(table2, "10000");
        //填充数据
        XWPFTableRow rowIndexa10 = table2.getRow(0);
        XWPFTableCell cell110 = rowIndexa10.getCell(0);
        cell110.setText("");
        cell110.setColor("5082bf");
        setCellStyle(cell110, "项目", true, "FFFFFF", 11);
        XWPFTableCell cell111 = rowIndexa10.getCell(1);
        cell111.setText("");
        cell111.setColor("5082bf");
        setCellStyle(cell111, "行业参考值（范围）", true, "FFFFFF", 11);
        XWPFTableCell cell112 = rowIndexa10.getCell(2);
        cell112.setText("");
        cell112.setColor("5082bf");
        setCellStyle(cell112, "偏差诊断及建议", true, "FFFFFF", 11);
        XWPFTableCell cell113 = rowIndexa10.getCell(3);
        cell113.setText("");
        cell113.setColor("5082bf");
        setCellStyle(cell113, "AkzoNobel解决方案", true, "FFFFFF", 11);

        List<Object[]> list5 = vo.getUnitOperationsReference();

        Object[] s1 = list5.get(0);
        Object[] s2 = list5.get(1);
        Object[] s3 = list5.get(2);
        Object[] s4 = list5.get(3);
        Object[] s5 = list5.get(4);
        Object[] s6 = list5.get(5);
        Object[] s7 = list5.get(6);
        Object[] s8 = list5.get(7);
        Object[] s9 = list5.get(8);

        XWPFTableRow rowIndexa11 = table2.getRow(1);
        XWPFTableCell cell120 = rowIndexa11.getCell(0);
        cell120.setText("");
        cell120.setColor("5082bf");
        setCellStyle(cell120, "单台车平均产值", true, "FFFFFF", 11);
        XWPFTableCell cell121 = rowIndexa11.getCell(1);
        cell121.setText("");
        cell121.setColor("b8cce4");
        setCellStyle(cell121, "850～2299", false, "000000", 10);
        XWPFTableCell cell122 = rowIndexa11.getCell(2);
        cell122.setText("");
        cell122.setColor("b8cce4");
        setCellStyle(cell122, s1[2].toString(), false, "000000", 10);
        XWPFTableCell cell123 = rowIndexa11.getCell(3);
        cell123.setText("");
        cell123.setColor("b8cce4");
        setCellStyle(cell123, s1[3].toString(), false, "000000", 10);

        XWPFTableRow rowIndexa12 = table2.getRow(2);
        XWPFTableCell cell130 = rowIndexa12.getCell(0);
        cell130.setText("");
        cell130.setColor("5082bf");
        setCellStyle(cell130, "平均单车面数", true, "FFFFFF", 11);
        XWPFTableCell cell131 = rowIndexa12.getCell(1);
        cell131.setText("");
        cell131.setColor("dbe5f1");
        setCellStyle(cell131, "1.8～2.6", false, "000000", 10);
        XWPFTableCell cell132 = rowIndexa12.getCell(2);
        cell132.setText("");
        cell132.setColor("dbe5f1");
        setCellStyle(cell132, s2[2].toString(), false, "000000", 10);
        XWPFTableCell cell133 = rowIndexa12.getCell(3);
        cell133.setText("");
        cell133.setColor("dbe5f1");
        setCellStyle(cell133, s2[3].toString(), false, "000000", 10);

        XWPFTableRow rowIndexa13 = table2.getRow(3);
        XWPFTableCell cell140 = rowIndexa13.getCell(0);
        cell140.setText("");
        cell140.setColor("5082bf");
        setCellStyle(cell140, "月均维修面数", true, "FFFFFF", 11);
        XWPFTableCell cell141 = rowIndexa13.getCell(1);
        cell141.setText("");
        cell141.setColor("b8cce4");
        setCellStyle(cell141, "", false, "000000", 10);
        XWPFTableCell cell142 = rowIndexa13.getCell(2);
        cell142.setText("");
        cell142.setColor("b8cce4");
        setCellStyle(cell142, "", false, "000000", 10);
        XWPFTableCell cell143 = rowIndexa13.getCell(3);
        cell143.setText("");
        cell143.setColor("b8cce4");
        setCellStyle(cell143, "", false, "000000", 10);

        XWPFTableRow rowIndexa14 = table2.getRow(4);
        XWPFTableCell cell150 = rowIndexa14.getCell(0);
        cell150.setText("");
        cell150.setColor("5082bf");
        setCellStyle(cell150, "单工位维修台次/月", true, "FFFFFF", 11);
        XWPFTableCell cell151 = rowIndexa14.getCell(1);
        cell151.setText("");
        cell151.setColor("dbe5f1");
        setCellStyle(cell151, "30～45台月", false, "000000", 10);
        XWPFTableCell cell152 = rowIndexa14.getCell(2);
        cell152.setText("");
        cell152.setColor("dbe5f1");
        setCellStyle(cell152, s4[2].toString(), false, "000000", 10);
        XWPFTableCell cell153 = rowIndexa14.getCell(3);
        cell153.setText("");
        cell153.setColor("dbe5f1");
        setCellStyle(cell153, s4[3].toString(), false, "000000", 10);

        XWPFTableRow rowIndexa15 = table2.getRow(5);
        XWPFTableCell cell160 = rowIndexa15.getCell(0);
        cell160.setText("");
        cell160.setColor("5082bf");
        setCellStyle(cell160, "单工位维修面数/月", true, "FFFFFF", 11);
        XWPFTableCell cell161 = rowIndexa15.getCell(1);
        cell161.setText("");
        cell161.setColor("b8cce4");
        setCellStyle(cell161, "60～75面/月", false, "000000", 10);
        XWPFTableCell cell162 = rowIndexa15.getCell(2);
        cell162.setText("");
        cell162.setColor("b8cce4");
        setCellStyle(cell162, s5[2].toString(), false, "000000", 10);
        XWPFTableCell cell163 = rowIndexa15.getCell(3);
        cell163.setText("");
        cell163.setColor("b8cce4");
        setCellStyle(cell163, s5[3].toString(), false, "000000", 10);

        XWPFTableRow rowIndexa16 = table2.getRow(6);
        XWPFTableCell cell170 = rowIndexa16.getCell(0);
        cell170.setText("");
        cell170.setColor("5082bf");
        setCellStyle(cell170, "单工人维修台次/月", true, "FFFFFF", 11);
        XWPFTableCell cell171 = rowIndexa16.getCell(1);
        cell171.setText("");
        cell171.setColor("dbe5f1");
        setCellStyle(cell171, "45～60台月", false, "000000", 10);
        XWPFTableCell cell172 = rowIndexa16.getCell(2);
        cell172.setText("");
        cell172.setColor("dbe5f1");
        setCellStyle(cell172, s6[2].toString(), false, "000000", 10);
        XWPFTableCell cell173 = rowIndexa16.getCell(3);
        cell173.setText("");
        cell173.setColor("dbe5f1");
        setCellStyle(cell173, s6[3].toString(), false, "000000", 10);

        XWPFTableRow rowIndexa17 = table2.getRow(7);
        XWPFTableCell cell180 = rowIndexa17.getCell(0);
        cell180.setText("");
        cell180.setColor("5082bf");
        setCellStyle(cell180, "单工人维修面数/月", true, "FFFFFF", 11);
        XWPFTableCell cell181 = rowIndexa17.getCell(1);
        cell181.setText("");
        cell181.setColor("b8cce4");
        setCellStyle(cell181, "90～120面/月", false, "000000", 10);
        XWPFTableCell cell182 = rowIndexa17.getCell(2);
        cell182.setText("");
        cell182.setColor("b8cce4");
        setCellStyle(cell182, s7[2].toString(), false, "000000", 10);
        XWPFTableCell cell183 = rowIndexa17.getCell(3);
        cell183.setText("");
        cell183.setColor("b8cce4");
        setCellStyle(cell183, s7[3].toString(), false, "000000", 10);

        XWPFTableRow rowIndexa18 = table2.getRow(8);
        XWPFTableCell cell190 = rowIndexa18.getCell(0);
        cell190.setText("");
        cell190.setColor("5082bf");
        setCellStyle(cell190, "单工位产值（元）", true, "FFFFFF", 11);
        XWPFTableCell cell191 = rowIndexa18.getCell(1);
        cell191.setText("");
        cell191.setColor("dbe5f1");
        setCellStyle(cell191, "", false, "000000", 10);
        XWPFTableCell cell192 = rowIndexa18.getCell(2);
        cell192.setText("");
        cell192.setColor("dbe5f1");
        setCellStyle(cell192, "", false, "000000", 10);
        XWPFTableCell cell193 = rowIndexa18.getCell(3);
        cell193.setText("");
        cell193.setColor("dbe5f1");
        setCellStyle(cell193, "", false, "000000", 10);

        XWPFTableRow rowIndexa19 = table2.getRow(9);
        XWPFTableCell cell1100 = rowIndexa19.getCell(0);
        cell1100.setText("");
        cell1100.setColor("5082bf");
        setCellStyle(cell1100, "单工人产值（元）", true, "FFFFFF", 11);
        XWPFTableCell cell1101 = rowIndexa19.getCell(1);
        cell1101.setText("");
        cell1101.setColor("b8cce4");
        setCellStyle(cell1101, "", false, "000000", 10);
        XWPFTableCell cell1102 = rowIndexa19.getCell(2);
        cell1102.setText("");
        cell1102.setColor("b8cce4");
        setCellStyle(cell1102, "", false, "000000", 10);
        XWPFTableCell cell1103 = rowIndexa19.getCell(3);
        cell1103.setText("");
        cell1103.setColor("b8cce4");
        setCellStyle(cell1103, "", false, "000000", 10);


        //添加标题
        XWPFParagraph titleParagraphhh1 = document.createParagraph();
        //设置段落居中
        titleParagraphhh1.setAlignment(ParagraphAlignment.LEFT);
        XWPFRun titleParagraphRunhh1 = titleParagraphhh1.createRun();
        titleParagraphRunhh1.setText("");
//        titleParagraphRun.setColor("000000");
        titleParagraphRunhh1.setFontSize(17);
        titleParagraphRunhh1.setFontFamily("微软雅黑");


        //创建表格
        int roww2 = 10;
        int columnn2 = 9;
        XWPFTable tablee2 = document.createTable(roww2, columnn2);
        setTableStyle(tablee2);
        setTableWidth(tablee2, "10000");
        //填充数据
        XWPFTableRow rowIndexxx10 = tablee2.getRow(0);
        XWPFTableCell cellll10 = rowIndexxx10.getCell(0);
        cellll10.setText("");
        cellll10.setColor("5082bf");
        setCellStyle(cellll10, "项目", true, "FFFFFF", 11);
        XWPFTableCell cellll11 = rowIndexxx10.getCell(1);
        cellll11.setText("");
        cellll11.setColor("5082bf");
        setCellStyle(cellll11, "改善前3个月", true, "FFFFFF", 11);
        XWPFTableCell cellll12 = rowIndexxx10.getCell(2);
        cellll12.setText("");
        cellll12.setColor("5082bf");
        setCellStyle(cellll12, "改善前2个月", true, "FFFFFF", 11);
        XWPFTableCell cellll13 = rowIndexxx10.getCell(3);
        cellll13.setText("");
        cellll13.setColor("5082bf");
        setCellStyle(cellll13, "改善前1个月", true, "FFFFFF", 11);
        XWPFTableCell cellll14 = rowIndexxx10.getCell(4);
        cellll14.setText("");
        cellll14.setColor("5082bf");
        setCellStyle(cellll14, "改善当月", true, "FFFFFF", 11);
        XWPFTableCell cellll15 = rowIndexxx10.getCell(5);
        cellll15.setText("");
        cellll15.setColor("5082bf");
        setCellStyle(cellll15, "改善后1个月", true, "FFFFFF", 11);
        XWPFTableCell cellll16 = rowIndexxx10.getCell(6);
        cellll16.setText("");
        cellll16.setColor("5082bf");
        setCellStyle(cellll16, "改善后2个月", true, "FFFFFF", 11);
        XWPFTableCell cellll17 = rowIndexxx10.getCell(7);
        cellll17.setText("");
        cellll17.setColor("5082bf");
        setCellStyle(cellll17, "改善后3个月", true, "FFFFFF", 11);
        XWPFTableCell cellll18 = rowIndexxx10.getCell(8);
        cellll18.setText("");
        cellll18.setColor("5082bf");
        setCellStyle(cellll18, "平均值", true, "FFFFFF", 11);


        List<Object[]> list2 = vo.getUnitOperations();

        Object[] p1 = list2.get(0);
        Object[] p2 = list2.get(1);
        Object[] p3 = list2.get(2);
        Object[] p4 = list2.get(3);
        Object[] p5 = list2.get(4);
        Object[] p6 = list2.get(5);
        Object[] p7 = list2.get(6);
        Object[] p8 = list2.get(7);

        XWPFTableRow rowIndexxx11 = tablee2.getRow(1);
        XWPFTableCell cellll20 = rowIndexxx11.getCell(0);
        cellll20.setText("");
        cellll20.setColor("5082bf");
        setCellStyle(cellll20, "单台车平均产值", true, "FFFFFF", 11);
        XWPFTableCell cellll21 = rowIndexxx11.getCell(1);
        cellll21.setText("");
        cellll21.setColor("b8cce4");
        setCellStyle(cellll21, p1[1].toString(), false, "000000", 10);
        XWPFTableCell cellll22 = rowIndexxx11.getCell(2);
        cellll22.setText("");
        cellll22.setColor("b8cce4");
        setCellStyle(cellll22, p2[1].toString(), false, "000000", 10);
        XWPFTableCell cellll23 = rowIndexxx11.getCell(3);
        cellll23.setText("");
        cellll23.setColor("b8cce4");
        setCellStyle(cellll23, p3[1].toString(), false, "000000", 10);
        XWPFTableCell cellll24 = rowIndexxx11.getCell(4);
        cellll24.setText("");
        cellll24.setColor("b8cce4");
        setCellStyle(cellll24, p4[1].toString(), false, "000000", 10);
        XWPFTableCell cellll25 = rowIndexxx11.getCell(5);
        cellll25.setText("");
        cellll25.setColor("b8cce4");
        setCellStyle(cellll25, p5[1].toString(), false, "000000", 10);
        XWPFTableCell cellll26 = rowIndexxx11.getCell(6);
        cellll26.setText("");
        cellll26.setColor("b8cce4");
        setCellStyle(cellll26, p6[1].toString(), false, "000000", 10);
        XWPFTableCell cellll27 = rowIndexxx11.getCell(7);
        cellll27.setText("");
        cellll27.setColor("b8cce4");
        setCellStyle(cellll27, p7[1].toString(), false, "000000", 10);
        XWPFTableCell cellll28 = rowIndexxx11.getCell(8);
        cellll28.setText("");
        cellll28.setColor("b8cce4");
        setCellStyle(cellll28, p8[1].toString(), false, "000000", 10);

        XWPFTableRow rowIndexxx12 = tablee2.getRow(2);
        XWPFTableCell cellll30 = rowIndexxx12.getCell(0);
        cellll30.setText("");
        cellll30.setColor("5082bf");
        setCellStyle(cellll30, "平均单车面数", true, "FFFFFF", 11);
        XWPFTableCell cellll31 = rowIndexxx12.getCell(1);
        cellll31.setText("");
        cellll31.setColor("dbe5f1");
        setCellStyle(cellll31, p1[2].toString(), false, "000000", 10);
        XWPFTableCell cellll32 = rowIndexxx12.getCell(2);
        cellll32.setText("");
        cellll32.setColor("dbe5f1");
        setCellStyle(cellll32, p2[2].toString(), false, "000000", 10);
        XWPFTableCell cellll33 = rowIndexxx12.getCell(3);
        cellll33.setText("");
        cellll33.setColor("dbe5f1");
        setCellStyle(cellll33, p3[2].toString(), false, "000000", 10);
        XWPFTableCell cellll34 = rowIndexxx12.getCell(4);
        cellll34.setText("");
        cellll34.setColor("dbe5f1");
        setCellStyle(cellll34, p4[2].toString(), false, "000000", 10);
        XWPFTableCell cellll35 = rowIndexxx12.getCell(5);
        cellll35.setText("");
        cellll35.setColor("dbe5f1");
        setCellStyle(cellll35, p5[2].toString(), false, "000000", 10);
        XWPFTableCell cellll36 = rowIndexxx12.getCell(6);
        cellll36.setText("");
        cellll36.setColor("dbe5f1");
        setCellStyle(cellll36, p6[2].toString(), false, "000000", 10);
        XWPFTableCell cellll37 = rowIndexxx12.getCell(7);
        cellll37.setText("");
        cellll37.setColor("dbe5f1");
        setCellStyle(cellll37, p7[2].toString(), false, "000000", 10);
        XWPFTableCell cellll38 = rowIndexxx12.getCell(8);
        cellll38.setText("");
        cellll38.setColor("dbe5f1");
        setCellStyle(cellll38, p8[2].toString(), false, "000000", 10);

        XWPFTableRow rowIndexxx13 = tablee2.getRow(3);
        XWPFTableCell cellll40 = rowIndexxx13.getCell(0);
        cellll40.setText("");
        cellll40.setColor("5082bf");
        setCellStyle(cellll40, "月均维修面数", true, "FFFFFF", 11);
        XWPFTableCell cellll41 = rowIndexxx13.getCell(1);
        cellll41.setText("");
        cellll41.setColor("b8cce4");
        setCellStyle(cellll41, p1[3].toString(), false, "000000", 10);
        XWPFTableCell cellll42 = rowIndexxx13.getCell(2);
        cellll42.setText("");
        cellll42.setColor("b8cce4");
        setCellStyle(cellll42, p2[3].toString(), false, "000000", 10);
        XWPFTableCell cellll43 = rowIndexxx13.getCell(3);
        cellll43.setText("");
        cellll43.setColor("b8cce4");
        setCellStyle(cellll43, p3[3].toString(), false, "000000", 10);
        XWPFTableCell cellll44 = rowIndexxx13.getCell(4);
        cellll44.setText("");
        cellll44.setColor("b8cce4");
        setCellStyle(cellll44, p4[3].toString(), false, "000000", 10);
        XWPFTableCell cellll45 = rowIndexxx13.getCell(5);
        cellll45.setText("");
        cellll45.setColor("b8cce4");
        setCellStyle(cellll45, p5[3].toString(), false, "000000", 10);
        XWPFTableCell cellll46 = rowIndexxx13.getCell(6);
        cellll46.setText("");
        cellll46.setColor("b8cce4");
        setCellStyle(cellll46, p6[3].toString(), false, "000000", 10);
        XWPFTableCell cellll47 = rowIndexxx13.getCell(7);
        cellll47.setText("");
        cellll47.setColor("b8cce4");
        setCellStyle(cellll47, p7[3].toString(), false, "000000", 10);
        XWPFTableCell cellll48 = rowIndexxx13.getCell(8);
        cellll48.setText("");
        cellll48.setColor("b8cce4");
        setCellStyle(cellll48, p8[3].toString(), false, "000000", 10);

        XWPFTableRow rowIndexxx14 = tablee2.getRow(4);
        XWPFTableCell cellll50 = rowIndexxx14.getCell(0);
        cellll50.setText("");
        cellll50.setColor("5082bf");
        setCellStyle(cellll50, "单工位维修台次/月", true, "FFFFFF", 11);
        XWPFTableCell cellll51 = rowIndexxx14.getCell(1);
        cellll51.setText("");
        cellll51.setColor("dbe5f1");
        setCellStyle(cellll51, p1[4].toString(), false, "000000", 10);
        XWPFTableCell cellll52 = rowIndexxx14.getCell(2);
        cellll52.setText("");
        cellll52.setColor("dbe5f1");
        setCellStyle(cellll52, p2[4].toString(), false, "000000", 10);
        XWPFTableCell cellll53 = rowIndexxx14.getCell(3);
        cellll53.setText("");
        cellll53.setColor("dbe5f1");
        setCellStyle(cellll53, p3[4].toString(), false, "000000", 10);
        XWPFTableCell cellll54 = rowIndexxx14.getCell(4);
        cellll54.setText("");
        cellll54.setColor("dbe5f1");
        setCellStyle(cellll54, p4[4].toString(), false, "000000", 10);
        XWPFTableCell cellll55 = rowIndexxx14.getCell(5);
        cellll55.setText("");
        cellll55.setColor("dbe5f1");
        setCellStyle(cellll55, p5[4].toString(), false, "000000", 10);
        XWPFTableCell cellll56 = rowIndexxx14.getCell(6);
        cellll56.setText("");
        cellll56.setColor("dbe5f1");
        setCellStyle(cellll56, p6[4].toString(), false, "000000", 10);
        XWPFTableCell cellll57 = rowIndexxx14.getCell(7);
        cellll57.setText("");
        cellll57.setColor("dbe5f1");
        setCellStyle(cellll57, p7[4].toString(), false, "000000", 10);
        XWPFTableCell cellll58 = rowIndexxx14.getCell(8);
        cellll58.setText("");
        cellll58.setColor("dbe5f1");
        setCellStyle(cellll58, p8[4].toString(), false, "000000", 10);

        XWPFTableRow rowIndexxx15 = tablee2.getRow(5);
        XWPFTableCell cellll60 = rowIndexxx15.getCell(0);
        cellll60.setText("");
        cellll60.setColor("5082bf");
        setCellStyle(cellll60, "单工位维修面数/月", true, "FFFFFF", 11);
        XWPFTableCell cellll61 = rowIndexxx15.getCell(1);
        cellll61.setText("");
        cellll61.setColor("b8cce4");
        setCellStyle(cellll61, p1[5].toString(), false, "000000", 10);
        XWPFTableCell cellll62 = rowIndexxx15.getCell(2);
        cellll62.setText("");
        cellll62.setColor("b8cce4");
        setCellStyle(cellll62, p2[5].toString(), false, "000000", 10);
        XWPFTableCell cellll63 = rowIndexxx15.getCell(3);
        cellll63.setText("");
        cellll63.setColor("b8cce4");
        setCellStyle(cellll63, p3[5].toString(), false, "000000", 10);
        XWPFTableCell cellll64 = rowIndexxx15.getCell(4);
        cellll64.setText("");
        cellll64.setColor("b8cce4");
        setCellStyle(cellll64, p4[5].toString(), false, "000000", 10);
        XWPFTableCell cellll65 = rowIndexxx15.getCell(5);
        cellll65.setText("");
        cellll65.setColor("b8cce4");
        setCellStyle(cellll65, p5[5].toString(), false, "000000", 10);
        XWPFTableCell cellll66 = rowIndexxx15.getCell(6);
        cellll66.setText("");
        cellll66.setColor("b8cce4");
        setCellStyle(cellll66, p6[5].toString(), false, "000000", 10);
        XWPFTableCell cellll67 = rowIndexxx15.getCell(7);
        cellll67.setText("");
        cellll67.setColor("b8cce4");
        setCellStyle(cellll67, p7[5].toString(), false, "000000", 10);
        XWPFTableCell cellll68 = rowIndexxx15.getCell(8);
        cellll68.setText("");
        cellll68.setColor("b8cce4");
        setCellStyle(cellll68, p8[5].toString(), false, "000000", 10);

        XWPFTableRow rowIndexxx16 = tablee2.getRow(6);
        XWPFTableCell cellll70 = rowIndexxx16.getCell(0);
        cellll70.setText("");
        cellll70.setColor("5082bf");
        setCellStyle(cellll70, "单工人维修台次/月", true, "FFFFFF", 11);
        XWPFTableCell cellll71 = rowIndexxx16.getCell(1);
        cellll71.setText("");
        cellll71.setColor("dbe5f1");
        setCellStyle(cellll71, p1[6].toString(), false, "000000", 10);
        XWPFTableCell cellll72 = rowIndexxx16.getCell(2);
        cellll72.setText("");
        cellll72.setColor("dbe5f1");
        setCellStyle(cellll72, p2[6].toString(), false, "000000", 10);
        XWPFTableCell cellll73 = rowIndexxx16.getCell(3);
        cellll73.setText("");
        cellll73.setColor("dbe5f1");
        setCellStyle(cellll73, p3[6].toString(), false, "000000", 10);
        XWPFTableCell cellll74 = rowIndexxx16.getCell(4);
        cellll74.setText("");
        cellll74.setColor("dbe5f1");
        setCellStyle(cellll74, p4[6].toString(), false, "000000", 10);
        XWPFTableCell cellll75 = rowIndexxx16.getCell(5);
        cellll75.setText("");
        cellll75.setColor("dbe5f1");
        setCellStyle(cellll75, p5[6].toString(), false, "000000", 10);
        XWPFTableCell cellll76 = rowIndexxx16.getCell(6);
        cellll76.setText("");
        cellll76.setColor("dbe5f1");
        setCellStyle(cellll76, p6[6].toString(), false, "000000", 10);
        XWPFTableCell cellll77 = rowIndexxx16.getCell(7);
        cellll77.setText("");
        cellll77.setColor("dbe5f1");
        setCellStyle(cellll77, p7[6].toString(), false, "000000", 10);
        XWPFTableCell cellll78 = rowIndexxx16.getCell(8);
        cellll78.setText("");
        cellll78.setColor("dbe5f1");
        setCellStyle(cellll78, p8[6].toString(), false, "000000", 10);

        XWPFTableRow rowIndexxx17 = tablee2.getRow(7);
        XWPFTableCell cellll80 = rowIndexxx17.getCell(0);
        cellll80.setText("");
        cellll80.setColor("5082bf");
        setCellStyle(cellll80, "单工人维修面数/月", true, "FFFFFF", 11);
        XWPFTableCell cellll81 = rowIndexxx17.getCell(1);
        cellll81.setText("");
        cellll81.setColor("b8cce4");
        setCellStyle(cellll81, p1[7].toString(), false, "000000", 10);
        XWPFTableCell cellll82 = rowIndexxx17.getCell(2);
        cellll82.setText("");
        cellll82.setColor("b8cce4");
        setCellStyle(cellll82, p2[7].toString(), false, "000000", 10);
        XWPFTableCell cellll83 = rowIndexxx17.getCell(3);
        cellll83.setText("");
        cellll83.setColor("b8cce4");
        setCellStyle(cellll83, p3[7].toString(), false, "000000", 10);
        XWPFTableCell cellll84 = rowIndexxx17.getCell(4);
        cellll84.setText("");
        cellll84.setColor("b8cce4");
        setCellStyle(cellll84, p4[7].toString(), false, "000000", 10);
        XWPFTableCell cellll85 = rowIndexxx17.getCell(5);
        cellll85.setText("");
        cellll85.setColor("b8cce4");
        setCellStyle(cellll85, p5[7].toString(), false, "000000", 10);
        XWPFTableCell cellll86 = rowIndexxx17.getCell(6);
        cellll86.setText("");
        cellll86.setColor("b8cce4");
        setCellStyle(cellll86, p6[7].toString(), false, "000000", 10);
        XWPFTableCell cellll87 = rowIndexxx17.getCell(7);
        cellll87.setText("");
        cellll87.setColor("b8cce4");
        setCellStyle(cellll87, p7[7].toString(), false, "000000", 10);
        XWPFTableCell cellll88 = rowIndexxx17.getCell(8);
        cellll88.setText("");
        cellll88.setColor("b8cce4");
        setCellStyle(cellll88, p8[7].toString(), false, "000000", 10);

        XWPFTableRow rowIndexxx18 = tablee2.getRow(8);
        XWPFTableCell cellll90 = rowIndexxx18.getCell(0);
        cellll90.setText("");
        cellll90.setColor("5082bf");
        setCellStyle(cellll90, "单工位产值（元）", true, "FFFFFF", 11);
        XWPFTableCell cellll91 = rowIndexxx18.getCell(1);
        cellll91.setText("");
        cellll91.setColor("dbe5f1");
        setCellStyle(cellll91, p1[8].toString(), false, "000000", 10);
        XWPFTableCell cellll92 = rowIndexxx18.getCell(2);
        cellll92.setText("");
        cellll92.setColor("dbe5f1");
        setCellStyle(cellll92, p2[8].toString(), false, "000000", 10);
        XWPFTableCell cellll93 = rowIndexxx18.getCell(3);
        cellll93.setText("");
        cellll93.setColor("dbe5f1");
        setCellStyle(cellll93, p3[8].toString(), false, "000000", 10);
        XWPFTableCell cellll94 = rowIndexxx18.getCell(4);
        cellll94.setText("");
        cellll94.setColor("dbe5f1");
        setCellStyle(cellll94, p4[8].toString(), false, "000000", 10);
        XWPFTableCell cellll95 = rowIndexxx18.getCell(5);
        cellll95.setText("");
        cellll95.setColor("dbe5f1");
        setCellStyle(cellll95, p5[8].toString(), false, "000000", 10);
        XWPFTableCell cellll96 = rowIndexxx18.getCell(6);
        cellll96.setText("");
        cellll96.setColor("dbe5f1");
        setCellStyle(cellll96, p6[8].toString(), false, "000000", 10);
        XWPFTableCell cellll97 = rowIndexxx18.getCell(7);
        cellll97.setText("");
        cellll97.setColor("dbe5f1");
        setCellStyle(cellll97, p7[8].toString(), false, "000000", 10);
        XWPFTableCell cellll98 = rowIndexxx18.getCell(8);
        cellll98.setText("");
        cellll98.setColor("dbe5f1");
        setCellStyle(cellll98, p8[8].toString(), false, "000000", 10);

        XWPFTableRow rowIndexxx19 = tablee2.getRow(9);
        XWPFTableCell cellll100 = rowIndexxx19.getCell(0);
        cellll100.setText("");
        cellll100.setColor("5082bf");
        setCellStyle(cellll100, "单工人产值（元）", true, "FFFFFF", 11);
        XWPFTableCell cellll101 = rowIndexxx19.getCell(1);
        cellll101.setText("");
        cellll101.setColor("b8cce4");
        setCellStyle(cellll101, p1[9].toString(), false, "000000", 10);
        XWPFTableCell cellll102 = rowIndexxx19.getCell(2);
        cellll102.setText("");
        cellll102.setColor("b8cce4");
        setCellStyle(cellll102, p2[9].toString(), false, "000000", 10);
        XWPFTableCell cellll103 = rowIndexxx19.getCell(3);
        cellll103.setText("");
        cellll103.setColor("b8cce4");
        setCellStyle(cellll103, p3[9].toString(), false, "000000", 10);
        XWPFTableCell cellll104 = rowIndexxx19.getCell(4);
        cellll104.setText("");
        cellll104.setColor("b8cce4");
        setCellStyle(cellll104, p4[9].toString(), false, "000000", 10);
        XWPFTableCell cellll105 = rowIndexxx19.getCell(5);
        cellll105.setText("");
        cellll105.setColor("b8cce4");
        setCellStyle(cellll105, p5[9].toString(), false, "000000", 10);
        XWPFTableCell cellll106 = rowIndexxx19.getCell(6);
        cellll106.setText("");
        cellll106.setColor("b8cce4");
        setCellStyle(cellll106, p6[9].toString(), false, "000000", 10);
        XWPFTableCell cellll107 = rowIndexxx19.getCell(7);
        cellll107.setText("");
        cellll107.setColor("b8cce4");
        setCellStyle(cellll107, p7[9].toString(), false, "000000", 10);
        XWPFTableCell cellll108 = rowIndexxx19.getCell(8);
        cellll108.setText("");
        cellll108.setColor("b8cce4");
        setCellStyle(cellll108, p8[9].toString(), false, "000000", 10);


        //添加标题
        XWPFParagraph titleParagraph3 = document.createParagraph();
        //设置段落居中
        titleParagraph3.setAlignment(ParagraphAlignment.LEFT);
        XWPFRun titleParagraphRun3 = titleParagraph3.createRun();
        titleParagraphRun3.setText("总体产能一览");
//        titleParagraphRun.setColor("000000");
        titleParagraphRun3.setFontSize(17);
        titleParagraphRun3.setFontFamily("微软雅黑");

        //创建表格 总体产能一览
        int row3 = 10;
        int column3 = 4;
        XWPFTable table3 = document.createTable(row3, column3);
        setTableStyle(table3);
        setTableWidth(table3, "10000");
        //填充数据
        XWPFTableRow rowIndexaaa10 = table3.getRow(0);
        XWPFTableCell celll110 = rowIndexaaa10.getCell(0);
        celll110.setText("");
        celll110.setColor("5082bf");
        setCellStyle(celll110, "项目", true, "FFFFFF", 11);
        XWPFTableCell celll111 = rowIndexaaa10.getCell(1);
        celll111.setText("");
        celll111.setColor("5082bf");
        setCellStyle(celll111, "行业参考值（范围）", true, "FFFFFF", 11);
        XWPFTableCell celll112 = rowIndexaaa10.getCell(2);
        celll112.setText("");
        celll112.setColor("5082bf");
        setCellStyle(celll112, "偏差诊断及建议", true, "FFFFFF", 11);
        XWPFTableCell celll113 = rowIndexaaa10.getCell(3);
        celll113.setText("");
        celll113.setColor("5082bf");
        setCellStyle(celll113, "AkzoNobel解决方案", true, "FFFFFF", 11);

        List<Object[]> list6 = vo.getOverallOperationsReference();

        Object[] t1 = list6.get(0);
        Object[] t2 = list6.get(1);
        Object[] t3 = list6.get(2);
        Object[] t4 = list6.get(3);
        Object[] t5 = list6.get(4);
        Object[] t6 = list6.get(5);
        Object[] t7 = list6.get(6);
        Object[] t8 = list6.get(7);
        Object[] t9 = list6.get(8);

        XWPFTableRow rowIndexaa11 = table3.getRow(1);
        XWPFTableCell celll120 = rowIndexaa11.getCell(0);
        celll120.setText("");
        celll120.setColor("5082bf");
        setCellStyle(celll120, "目前烤房最大产能（台）", true, "FFFFFF", 11);
        XWPFTableCell celll121 = rowIndexaa11.getCell(1);
        celll121.setText("");
        celll121.setColor("b8cce4");
        setCellStyle(celll121, "165台/月", false, "000000", 10);
        XWPFTableCell celll122 = rowIndexaa11.getCell(2);
        celll122.setText("");
        celll122.setColor("b8cce4");
        setCellStyle(celll122, t1[2].toString(), false, "000000", 10);
        XWPFTableCell celll123 = rowIndexaa11.getCell(3);
        celll123.setText("");
        celll123.setColor("b8cce4");
        setCellStyle(celll123, t1[3].toString(), false, "000000", 10);

        XWPFTableRow rowIndexaa12 = table3.getRow(2);
        XWPFTableCell celll130 = rowIndexaa12.getCell(0);
        celll130.setText("");
        celll130.setColor("5082bf");
        setCellStyle(celll130, "目前烤房最大产能（面）", true, "FFFFFF", 11);
        XWPFTableCell celll131 = rowIndexaa12.getCell(1);
        celll131.setText("");
        celll131.setColor("dbe5f1");
        setCellStyle(celll131, "300～450件/月", false, "000000", 10);
        XWPFTableCell celll132 = rowIndexaa12.getCell(2);
        celll132.setText("");
        celll132.setColor("dbe5f1");
        setCellStyle(celll132, t2[2].toString(), false, "000000", 10);
        XWPFTableCell celll133 = rowIndexaa12.getCell(3);
        celll133.setText("");
        celll133.setColor("dbe5f1");
        setCellStyle(celll133, t2[3].toString(), false, "000000", 10);

        XWPFTableRow rowIndexaa13 = table3.getRow(3);
        XWPFTableCell celll140 = rowIndexaa13.getCell(0);
        celll140.setText("");
        celll140.setColor("5082bf");
        setCellStyle(celll140, "烤房利用率", true, "FFFFFF", 11);
        XWPFTableCell celll141 = rowIndexaa13.getCell(1);
        celll141.setText("");
        celll141.setColor("b8cce4");
        setCellStyle(celll141, "80%", false, "000000", 10);
        XWPFTableCell celll142 = rowIndexaa13.getCell(2);
        celll142.setText("");
        celll142.setColor("b8cce4");
        setCellStyle(celll142, t3[2].toString(), false, "000000", 10);
        XWPFTableCell celll143 = rowIndexaa13.getCell(3);
        celll143.setText("");
        celll143.setColor("b8cce4");
        setCellStyle(celll143, t3[3].toString(), false, "000000", 10);

        XWPFTableRow rowIndexaa14 = table3.getRow(4);
        XWPFTableCell celll150 = rowIndexaa14.getCell(0);
        celll150.setText("");
        celll150.setColor("5082bf");
        setCellStyle(celll150, "目前工人最大产能（台）", true, "FFFFFF", 11);
        XWPFTableCell celll151 = rowIndexaa14.getCell(1);
        celll151.setText("");
        celll151.setColor("dbe5f1");
        setCellStyle(celll151, "45～60台/月", false, "000000", 10);
        XWPFTableCell celll152 = rowIndexaa14.getCell(2);
        celll152.setText("");
        celll152.setColor("dbe5f1");
        setCellStyle(celll152, t4[2].toString(), false, "000000", 10);
        XWPFTableCell celll153 = rowIndexaa14.getCell(3);
        celll153.setText("");
        celll153.setColor("dbe5f1");
        setCellStyle(celll153, t4[3].toString(), false, "000000", 10);

        XWPFTableRow rowIndexaa15 = table3.getRow(5);
        XWPFTableCell celll160 = rowIndexaa15.getCell(0);
        celll160.setText("");
        celll160.setColor("5082bf");
        setCellStyle(celll160, "目前工人最大产能（面）", true, "FFFFFF", 11);
        XWPFTableCell celll161 = rowIndexaa15.getCell(1);
        celll161.setText("");
        celll161.setColor("b8cce4");
        setCellStyle(celll161, "90～120面/月", false, "000000", 10);
        XWPFTableCell celll162 = rowIndexaa15.getCell(2);
        celll162.setText("");
        celll162.setColor("b8cce4");
        setCellStyle(celll162, t5[2].toString(), false, "000000", 10);
        XWPFTableCell celll163 = rowIndexaa15.getCell(3);
        celll163.setText("");
        celll163.setColor("b8cce4");
        setCellStyle(celll163, t5[3].toString(), false, "000000", 10);

        XWPFTableRow rowIndexaa16 = table3.getRow(6);
        XWPFTableCell celll170 = rowIndexaa16.getCell(0);
        celll170.setText("");
        celll170.setColor("5082bf");
        setCellStyle(celll170, "工人利用率", true, "FFFFFF", 11);
        XWPFTableCell celll171 = rowIndexaa16.getCell(1);
        celll171.setText("");
        celll171.setColor("dbe5f1");
        setCellStyle(celll171, "80%", false, "000000", 10);
        XWPFTableCell celll172 = rowIndexaa16.getCell(2);
        celll172.setText("");
        celll172.setColor("dbe5f1");
        setCellStyle(celll172, t6[2].toString(), false, "000000", 10);
        XWPFTableCell celll173 = rowIndexaa16.getCell(3);
        celll173.setText("");
        celll173.setColor("dbe5f1");
        setCellStyle(celll173, t6[3].toString(), false, "000000", 10);

        XWPFTableRow rowIndexaa17 = table3.getRow(7);
        XWPFTableCell celll180 = rowIndexaa17.getCell(0);
        celll180.setText("");
        celll180.setColor("5082bf");
        setCellStyle(celll180, "目前工位最大产能（台）", true, "FFFFFF", 11);
        XWPFTableCell celll181 = rowIndexaa17.getCell(1);
        celll181.setText("");
        celll181.setColor("b8cce4");
        setCellStyle(celll181, "单工位30～45台/月", false, "000000", 10);
        XWPFTableCell celll182 = rowIndexaa17.getCell(2);
        celll182.setText("");
        celll182.setColor("b8cce4");
        setCellStyle(celll182, t7[2].toString(), false, "000000", 10);
        XWPFTableCell celll183 = rowIndexaa17.getCell(3);
        celll183.setText("");
        celll183.setColor("b8cce4");
        setCellStyle(celll183, t7[3].toString(), false, "000000", 10);

        XWPFTableRow rowIndexaa18 = table3.getRow(8);
        XWPFTableCell celll190 = rowIndexaa18.getCell(0);
        celll190.setText("");
        celll190.setColor("5082bf");
        setCellStyle(celll190, "目前工位最大产能（面）", true, "FFFFFF", 11);
        XWPFTableCell celll191 = rowIndexaa18.getCell(1);
        celll191.setText("");
        celll191.setColor("dbe5f1");
        setCellStyle(celll191, "单工位60～75面/月", false, "000000", 10);
        XWPFTableCell celll192 = rowIndexaa18.getCell(2);
        celll192.setText("");
        celll192.setColor("dbe5f1");
        setCellStyle(celll192, t8[2].toString(), false, "000000", 10);
        XWPFTableCell celll193 = rowIndexaa18.getCell(3);
        celll193.setText("");
        celll193.setColor("dbe5f1");
        setCellStyle(celll193, t8[3].toString(), false, "000000", 10);

        XWPFTableRow rowIndexaa19 = table3.getRow(9);
        XWPFTableCell celll1100 = rowIndexaa19.getCell(0);
        celll1100.setText("");
        celll1100.setColor("5082bf");
        setCellStyle(celll1100, "工位利用率", true, "FFFFFF", 11);
        XWPFTableCell celll1101 = rowIndexaa19.getCell(1);
        celll1101.setText("");
        celll1101.setColor("b8cce4");
        setCellStyle(celll1101, "100%", false, "000000", 10);
        XWPFTableCell celll1102 = rowIndexaa19.getCell(2);
        celll1102.setText("");
        celll1102.setColor("b8cce4");
        setCellStyle(celll1102, t9[2].toString(), false, "000000", 10);
        XWPFTableCell celll1103 = rowIndexaa19.getCell(3);
        celll1103.setText("");
        celll1103.setColor("b8cce4");
        setCellStyle(celll1103, t9[3].toString(), false, "000000", 10);


        //添加标题
        XWPFParagraph titleParagraphhhh1 = document.createParagraph();
        //设置段落居中
        titleParagraphhhh1.setAlignment(ParagraphAlignment.LEFT);
        XWPFRun titleParagraphRunhhh1 = titleParagraphhhh1.createRun();
        titleParagraphRunhhh1.setText("");
//        titleParagraphRun.setColor("000000");
        titleParagraphRunhhh1.setFontSize(17);
        titleParagraphRunhhh1.setFontFamily("微软雅黑");


        //创建表格
        int roww3 = 10;
        int columnn3 = 9;
        XWPFTable tablee3 = document.createTable(roww3, columnn3);
        setTableStyle(tablee3);
        setTableWidth(tablee3, "10000");
        //填充数据
        XWPFTableRow rowIndexxxx10 = tablee3.getRow(0);
        XWPFTableCell celllll10 = rowIndexxxx10.getCell(0);
        celllll10.setText("");
        celllll10.setColor("5082bf");
        setCellStyle(celllll10, "项目", true, "FFFFFF", 11);
        XWPFTableCell celllll11 = rowIndexxxx10.getCell(1);
        celllll11.setText("");
        celllll11.setColor("5082bf");
        setCellStyle(celllll11, "改善前3个月", true, "FFFFFF", 11);
        XWPFTableCell celllll12 = rowIndexxxx10.getCell(2);
        celllll12.setText("");
        celllll12.setColor("5082bf");
        setCellStyle(celllll12, "改善前2个月", true, "FFFFFF", 11);
        XWPFTableCell celllll13 = rowIndexxxx10.getCell(3);
        celllll13.setText("");
        celllll13.setColor("5082bf");
        setCellStyle(celllll13, "改善前1个月", true, "FFFFFF", 11);
        XWPFTableCell celllll14 = rowIndexxxx10.getCell(4);
        celllll14.setText("");
        celllll14.setColor("5082bf");
        setCellStyle(celllll14, "改善当月", true, "FFFFFF", 11);
        XWPFTableCell celllll15 = rowIndexxxx10.getCell(5);
        celllll15.setText("");
        celllll15.setColor("5082bf");
        setCellStyle(celllll15, "改善后1个月", true, "FFFFFF", 11);
        XWPFTableCell celllll16 = rowIndexxxx10.getCell(6);
        celllll16.setText("");
        celllll16.setColor("5082bf");
        setCellStyle(celllll16, "改善后2个月", true, "FFFFFF", 11);
        XWPFTableCell celllll17 = rowIndexxxx10.getCell(7);
        celllll17.setText("");
        celllll17.setColor("5082bf");
        setCellStyle(celllll17, "改善后3个月", true, "FFFFFF", 11);
        XWPFTableCell celllll18 = rowIndexxxx10.getCell(8);
        celllll18.setText("");
        celllll18.setColor("5082bf");
        setCellStyle(celllll18, "平均值", true, "FFFFFF", 11);


        List<Object[]> list3 = vo.getOverallOperations();

        Object[] q1 = list3.get(0);
        Object[] q2 = list3.get(1);
        Object[] q3 = list3.get(2);
        Object[] q4 = list3.get(3);
        Object[] q5 = list3.get(4);
        Object[] q6 = list3.get(5);
        Object[] q7 = list3.get(6);
        Object[] q8 = list3.get(7);


        XWPFTableRow rowIndexxxx11 = tablee3.getRow(1);
        XWPFTableCell celllll20 = rowIndexxxx11.getCell(0);
        celllll20.setText("");
        celllll20.setColor("5082bf");
        setCellStyle(celllll20, "目前烤房最大产能（台）", true, "FFFFFF", 11);
        XWPFTableCell celllll21 = rowIndexxxx11.getCell(1);
        celllll21.setText("");
        celllll21.setColor("b8cce4");
        setCellStyle(celllll21, q1[1].toString(), false, "000000", 10);
        XWPFTableCell celllll22 = rowIndexxxx11.getCell(2);
        celllll22.setText("");
        celllll22.setColor("b8cce4");
        setCellStyle(celllll22, q2[1].toString(), false, "000000", 10);
        XWPFTableCell celllll23 = rowIndexxxx11.getCell(3);
        celllll23.setText("");
        celllll23.setColor("b8cce4");
        setCellStyle(celllll23, q3[1].toString(), false, "000000", 10);
        XWPFTableCell celllll24 = rowIndexxxx11.getCell(4);
        celllll24.setText("");
        celllll24.setColor("b8cce4");
        setCellStyle(celllll24, q4[1].toString(), false, "000000", 10);
        XWPFTableCell celllll25 = rowIndexxxx11.getCell(5);
        celllll25.setText("");
        celllll25.setColor("b8cce4");
        setCellStyle(celllll25, q5[1].toString(), false, "000000", 10);
        XWPFTableCell celllll26 = rowIndexxxx11.getCell(6);
        celllll26.setText("");
        celllll26.setColor("b8cce4");
        setCellStyle(celllll26, q6[1].toString(), false, "000000", 10);
        XWPFTableCell celllll27 = rowIndexxxx11.getCell(7);
        celllll27.setText("");
        celllll27.setColor("b8cce4");
        setCellStyle(celllll27, q7[1].toString(), false, "000000", 10);
        XWPFTableCell celllll28 = rowIndexxxx11.getCell(8);
        celllll28.setText("");
        celllll28.setColor("b8cce4");
        setCellStyle(celllll28, q8[1].toString(), false, "000000", 10);

        XWPFTableRow rowIndexxxx12 = tablee3.getRow(2);
        XWPFTableCell celllll30 = rowIndexxxx12.getCell(0);
        celllll30.setText("");
        celllll30.setColor("5082bf");
        setCellStyle(celllll30, "目前烤房最大产能（面）", true, "FFFFFF", 11);
        XWPFTableCell celllll31 = rowIndexxxx12.getCell(1);
        celllll31.setText("");
        celllll31.setColor("dbe5f1");
        setCellStyle(celllll31, q1[2].toString(), false, "000000", 10);
        XWPFTableCell celllll32 = rowIndexxxx12.getCell(2);
        celllll32.setText("");
        celllll32.setColor("dbe5f1");
        setCellStyle(celllll32, q2[2].toString(), false, "000000", 10);
        XWPFTableCell celllll33 = rowIndexxxx12.getCell(3);
        celllll33.setText("");
        celllll33.setColor("dbe5f1");
        setCellStyle(celllll33, q3[2].toString(), false, "000000", 10);
        XWPFTableCell celllll34 = rowIndexxxx12.getCell(4);
        celllll34.setText("");
        celllll34.setColor("dbe5f1");
        setCellStyle(celllll34, q4[2].toString(), false, "000000", 10);
        XWPFTableCell celllll35 = rowIndexxxx12.getCell(5);
        celllll35.setText("");
        celllll35.setColor("dbe5f1");
        setCellStyle(celllll35, q5[2].toString(), false, "000000", 10);
        XWPFTableCell celllll36 = rowIndexxxx12.getCell(6);
        celllll36.setText("");
        celllll36.setColor("dbe5f1");
        setCellStyle(celllll36, q6[2].toString(), false, "000000", 10);
        XWPFTableCell celllll37 = rowIndexxxx12.getCell(7);
        celllll37.setText("");
        celllll37.setColor("dbe5f1");
        setCellStyle(celllll37, q7[2].toString(), false, "000000", 10);
        XWPFTableCell celllll38 = rowIndexxxx12.getCell(8);
        celllll38.setText("");
        celllll38.setColor("dbe5f1");
        setCellStyle(celllll38, q8[2].toString(), false, "000000", 10);

        XWPFTableRow rowIndexxxx13 = tablee3.getRow(3);
        XWPFTableCell celllll40 = rowIndexxxx13.getCell(0);
        celllll40.setText("");
        celllll40.setColor("5082bf");
        setCellStyle(celllll40, "烤房利用率", true, "FFFFFF", 11);
        XWPFTableCell celllll41 = rowIndexxxx13.getCell(1);
        celllll41.setText("");
        celllll41.setColor("b8cce4");
        setCellStyle(celllll41, q1[3].toString(), false, "000000", 10);
        XWPFTableCell celllll42 = rowIndexxxx13.getCell(2);
        celllll42.setText("");
        celllll42.setColor("b8cce4");
        setCellStyle(celllll42, q2[3].toString(), false, "000000", 10);
        XWPFTableCell celllll43 = rowIndexxxx13.getCell(3);
        celllll43.setText("");
        celllll43.setColor("b8cce4");
        setCellStyle(celllll43, q3[3].toString(), false, "000000", 10);
        XWPFTableCell celllll44 = rowIndexxxx13.getCell(4);
        celllll44.setText("");
        celllll44.setColor("b8cce4");
        setCellStyle(celllll44, q4[3].toString(), false, "000000", 10);
        XWPFTableCell celllll45 = rowIndexxxx13.getCell(5);
        celllll45.setText("");
        celllll45.setColor("b8cce4");
        setCellStyle(celllll45, q5[3].toString(), false, "000000", 10);
        XWPFTableCell celllll46 = rowIndexxxx13.getCell(6);
        celllll46.setText("");
        celllll46.setColor("b8cce4");
        setCellStyle(celllll46, q6[3].toString(), false, "000000", 10);
        XWPFTableCell celllll47 = rowIndexxxx13.getCell(7);
        celllll47.setText("");
        celllll47.setColor("b8cce4");
        setCellStyle(celllll47, q7[3].toString(), false, "000000", 10);
        XWPFTableCell celllll48 = rowIndexxxx13.getCell(8);
        celllll48.setText("");
        celllll48.setColor("b8cce4");
        setCellStyle(celllll48, q8[3].toString(), false, "000000", 10);

        XWPFTableRow rowIndexxxx14 = tablee3.getRow(4);
        XWPFTableCell celllll50 = rowIndexxxx14.getCell(0);
        celllll50.setText("");
        celllll50.setColor("5082bf");
        setCellStyle(celllll50, "目前工人最大产能（台）", true, "FFFFFF", 11);
        XWPFTableCell celllll51 = rowIndexxxx14.getCell(1);
        celllll51.setText("");
        celllll51.setColor("dbe5f1");
        setCellStyle(celllll51, q1[4].toString(), false, "000000", 10);
        XWPFTableCell celllll52 = rowIndexxxx14.getCell(2);
        celllll52.setText("");
        celllll52.setColor("dbe5f1");
        setCellStyle(celllll52, q2[4].toString(), false, "000000", 10);
        XWPFTableCell celllll53 = rowIndexxxx14.getCell(3);
        celllll53.setText("");
        celllll53.setColor("dbe5f1");
        setCellStyle(celllll53, q3[4].toString(), false, "000000", 10);
        XWPFTableCell celllll54 = rowIndexxxx14.getCell(4);
        celllll54.setText("");
        celllll54.setColor("dbe5f1");
        setCellStyle(celllll54, q4[4].toString(), false, "000000", 10);
        XWPFTableCell celllll55 = rowIndexxxx14.getCell(5);
        celllll55.setText("");
        celllll55.setColor("dbe5f1");
        setCellStyle(celllll55, q5[4].toString(), false, "000000", 10);
        XWPFTableCell celllll56 = rowIndexxxx14.getCell(6);
        celllll56.setText("");
        celllll56.setColor("dbe5f1");
        setCellStyle(celllll56, q6[4].toString(), false, "000000", 10);
        XWPFTableCell celllll57 = rowIndexxxx14.getCell(7);
        celllll57.setText("");
        celllll57.setColor("dbe5f1");
        setCellStyle(celllll57, q7[4].toString(), false, "000000", 10);
        XWPFTableCell celllll58 = rowIndexxxx14.getCell(8);
        celllll58.setText("");
        celllll58.setColor("dbe5f1");
        setCellStyle(celllll58, q8[4].toString(), false, "000000", 10);

        XWPFTableRow rowIndexxxx15 = tablee3.getRow(5);
        XWPFTableCell celllll60 = rowIndexxxx15.getCell(0);
        celllll60.setText("");
        celllll60.setColor("5082bf");
        setCellStyle(celllll60, "目前工人最大产能（面）", true, "FFFFFF", 11);
        XWPFTableCell celllll61 = rowIndexxxx15.getCell(1);
        celllll61.setText("");
        celllll61.setColor("b8cce4");
        setCellStyle(celllll61, q1[5].toString(), false, "000000", 10);
        XWPFTableCell celllll62 = rowIndexxxx15.getCell(2);
        celllll62.setText("");
        celllll62.setColor("b8cce4");
        setCellStyle(celllll62, q2[5].toString(), false, "000000", 10);
        XWPFTableCell celllll63 = rowIndexxxx15.getCell(3);
        celllll63.setText("");
        celllll63.setColor("b8cce4");
        setCellStyle(celllll63, q3[5].toString(), false, "000000", 10);
        XWPFTableCell celllll64 = rowIndexxxx15.getCell(4);
        celllll64.setText("");
        celllll64.setColor("b8cce4");
        setCellStyle(celllll64, q4[5].toString(), false, "000000", 10);
        XWPFTableCell celllll65 = rowIndexxxx15.getCell(5);
        celllll65.setText("");
        celllll65.setColor("b8cce4");
        setCellStyle(celllll65, q5[5].toString(), false, "000000", 10);
        XWPFTableCell celllll66 = rowIndexxxx15.getCell(6);
        celllll66.setText("");
        celllll66.setColor("b8cce4");
        setCellStyle(celllll66, q6[5].toString(), false, "000000", 10);
        XWPFTableCell celllll67 = rowIndexxxx15.getCell(7);
        celllll67.setText("");
        celllll67.setColor("b8cce4");
        setCellStyle(celllll67, q7[5].toString(), false, "000000", 10);
        XWPFTableCell celllll68 = rowIndexxxx15.getCell(8);
        celllll68.setText("");
        celllll68.setColor("b8cce4");
        setCellStyle(celllll68, q8[5].toString(), false, "000000", 10);

        XWPFTableRow rowIndexxxx16 = tablee3.getRow(6);
        XWPFTableCell celllll70 = rowIndexxxx16.getCell(0);
        celllll70.setText("");
        celllll70.setColor("5082bf");
        setCellStyle(celllll70, "工人利用率", true, "FFFFFF", 11);
        XWPFTableCell celllll71 = rowIndexxxx16.getCell(1);
        celllll71.setText("");
        celllll71.setColor("dbe5f1");
        setCellStyle(celllll71, q1[6].toString(), false, "000000", 10);
        XWPFTableCell celllll72 = rowIndexxxx16.getCell(2);
        celllll72.setText("");
        celllll72.setColor("dbe5f1");
        setCellStyle(celllll72, q2[6].toString(), false, "000000", 10);
        XWPFTableCell celllll73 = rowIndexxxx16.getCell(3);
        celllll73.setText("");
        celllll73.setColor("dbe5f1");
        setCellStyle(celllll73, q3[6].toString(), false, "000000", 10);
        XWPFTableCell celllll74 = rowIndexxxx16.getCell(4);
        celllll74.setText("");
        celllll74.setColor("dbe5f1");
        setCellStyle(celllll74, q4[6].toString(), false, "000000", 10);
        XWPFTableCell celllll75 = rowIndexxxx16.getCell(5);
        celllll75.setText("");
        celllll75.setColor("dbe5f1");
        setCellStyle(celllll75, q5[6].toString(), false, "000000", 10);
        XWPFTableCell celllll76 = rowIndexxxx16.getCell(6);
        celllll76.setText("");
        celllll76.setColor("dbe5f1");
        setCellStyle(celllll76, q6[6].toString(), false, "000000", 10);
        XWPFTableCell celllll77 = rowIndexxxx16.getCell(7);
        celllll77.setText("");
        celllll77.setColor("dbe5f1");
        setCellStyle(celllll77, q7[6].toString(), false, "000000", 10);
        XWPFTableCell celllll78 = rowIndexxxx16.getCell(8);
        celllll78.setText("");
        celllll78.setColor("dbe5f1");
        setCellStyle(celllll78, q8[6].toString(), false, "000000", 10);

        XWPFTableRow rowIndexxxx17 = tablee3.getRow(7);
        XWPFTableCell celllll80 = rowIndexxxx17.getCell(0);
        celllll80.setText("");
        celllll80.setColor("5082bf");
        setCellStyle(celllll80, "目前工位最大产能（台）", true, "FFFFFF", 11);
        XWPFTableCell celllll81 = rowIndexxxx17.getCell(1);
        celllll81.setText("");
        celllll81.setColor("b8cce4");
        setCellStyle(celllll81, q1[7].toString(), false, "000000", 10);
        XWPFTableCell celllll82 = rowIndexxxx17.getCell(2);
        celllll82.setText("");
        celllll82.setColor("b8cce4");
        setCellStyle(celllll82, q2[7].toString(), false, "000000", 10);
        XWPFTableCell celllll83 = rowIndexxxx17.getCell(3);
        celllll83.setText("");
        celllll83.setColor("b8cce4");
        setCellStyle(celllll83, q3[7].toString(), false, "000000", 10);
        XWPFTableCell celllll84 = rowIndexxxx17.getCell(4);
        celllll84.setText("");
        celllll84.setColor("b8cce4");
        setCellStyle(celllll84, q4[7].toString(), false, "000000", 10);
        XWPFTableCell celllll85 = rowIndexxxx17.getCell(5);
        celllll85.setText("");
        celllll85.setColor("b8cce4");
        setCellStyle(celllll85, q5[7].toString(), false, "000000", 10);
        XWPFTableCell celllll86 = rowIndexxxx17.getCell(6);
        celllll86.setText("");
        celllll86.setColor("b8cce4");
        setCellStyle(celllll86, q6[7].toString(), false, "000000", 10);
        XWPFTableCell celllll87 = rowIndexxxx17.getCell(7);
        celllll87.setText("");
        celllll87.setColor("b8cce4");
        setCellStyle(celllll87, q7[7].toString(), false, "000000", 10);
        XWPFTableCell celllll88 = rowIndexxxx17.getCell(8);
        celllll88.setText("");
        celllll88.setColor("b8cce4");
        setCellStyle(celllll88, q8[7].toString(), false, "000000", 10);

        XWPFTableRow rowIndexxxx18 = tablee3.getRow(8);
        XWPFTableCell celllll90 = rowIndexxxx18.getCell(0);
        celllll90.setText("");
        celllll90.setColor("5082bf");
        setCellStyle(celllll90, "目前工位最大产能（面）", true, "FFFFFF", 11);
        XWPFTableCell celllll91 = rowIndexxxx18.getCell(1);
        celllll91.setText("");
        celllll91.setColor("dbe5f1");
        setCellStyle(celllll91, q1[8].toString(), false, "000000", 10);
        XWPFTableCell celllll92 = rowIndexxxx18.getCell(2);
        celllll92.setText("");
        celllll92.setColor("dbe5f1");
        setCellStyle(celllll92, q2[8].toString(), false, "000000", 10);
        XWPFTableCell celllll93 = rowIndexxxx18.getCell(3);
        celllll93.setText("");
        celllll93.setColor("dbe5f1");
        setCellStyle(celllll93, q3[8].toString(), false, "000000", 10);
        XWPFTableCell celllll94 = rowIndexxxx18.getCell(4);
        celllll94.setText("");
        celllll94.setColor("dbe5f1");
        setCellStyle(celllll94, q4[8].toString(), false, "000000", 10);
        XWPFTableCell celllll95 = rowIndexxxx18.getCell(5);
        celllll95.setText("");
        celllll95.setColor("dbe5f1");
        setCellStyle(celllll95, q5[8].toString(), false, "000000", 10);
        XWPFTableCell celllll96 = rowIndexxxx18.getCell(6);
        celllll96.setText("");
        celllll96.setColor("dbe5f1");
        setCellStyle(celllll96, q6[8].toString(), false, "000000", 10);
        XWPFTableCell celllll97 = rowIndexxxx18.getCell(7);
        celllll97.setText("");
        celllll97.setColor("dbe5f1");
        setCellStyle(celllll97, q7[8].toString(), false, "000000", 10);
        XWPFTableCell celllll98 = rowIndexxxx18.getCell(8);
        celllll98.setText("");
        celllll98.setColor("dbe5f1");
        setCellStyle(celllll98, q8[8].toString(), false, "000000", 10);

        XWPFTableRow rowIndexxxx19 = tablee3.getRow(9);
        XWPFTableCell celllll100 = rowIndexxxx19.getCell(0);
        celllll100.setText("");
        celllll100.setColor("5082bf");
        setCellStyle(celllll100, "工位利用率", true, "FFFFFF", 11);
        XWPFTableCell celllll101 = rowIndexxxx19.getCell(1);
        celllll101.setText("");
        celllll101.setColor("b8cce4");
        setCellStyle(celllll101, q1[9].toString(), false, "000000", 10);
        XWPFTableCell celllll102 = rowIndexxxx19.getCell(2);
        celllll102.setText("");
        celllll102.setColor("b8cce4");
        setCellStyle(celllll102, q2[9].toString(), false, "000000", 10);
        XWPFTableCell celllll103 = rowIndexxxx19.getCell(3);
        celllll103.setText("");
        celllll103.setColor("b8cce4");
        setCellStyle(celllll103, q3[9].toString(), false, "000000", 10);
        XWPFTableCell celllll104 = rowIndexxxx19.getCell(4);
        celllll104.setText("");
        celllll104.setColor("b8cce4");
        setCellStyle(celllll104, q4[9].toString(), false, "000000", 10);
        XWPFTableCell celllll105 = rowIndexxxx19.getCell(5);
        celllll105.setText("");
        celllll105.setColor("b8cce4");
        setCellStyle(celllll105, q5[9].toString(), false, "000000", 10);
        XWPFTableCell celllll106 = rowIndexxxx19.getCell(6);
        celllll106.setText("");
        celllll106.setColor("b8cce4");
        setCellStyle(celllll106, q6[9].toString(), false, "000000", 10);
        XWPFTableCell celllll107 = rowIndexxxx19.getCell(7);
        celllll107.setText("");
        celllll107.setColor("b8cce4");
        setCellStyle(celllll107, q7[9].toString(), false, "000000", 10);
        XWPFTableCell celllll108 = rowIndexxxx19.getCell(8);
        celllll108.setText("");
        celllll108.setColor("b8cce4");
        setCellStyle(celllll108, q8[9].toString(), false, "000000", 10);

        //添加标题
        XWPFParagraph titleParagraph4 = document.createParagraph();
        //设置段落居中
        titleParagraph4.setAlignment(ParagraphAlignment.LEFT);
        XWPFRun titleParagraphRun4 = titleParagraph4.createRun();
        titleParagraphRun4.setText("经济性数据");
//        titleParagraphRun.setColor("000000");
        titleParagraphRun4.setFontSize(17);
        titleParagraphRun4.setFontFamily("微软雅黑");

        //创建表格 经济性数据
        int row4 = 8;
        int column4 = 4;
        XWPFTable table4 = document.createTable(row4, column4);
        setTableStyle(table4);
        setTableWidth(table4, "10000");
        //填充数据
        XWPFTableRow rowIndexaaaa10 = table4.getRow(0);
        XWPFTableCell cellll110 = rowIndexaaaa10.getCell(0);
        cellll110.setText("");
        cellll110.setColor("5082bf");
        setCellStyle(cellll110, "项目", true, "FFFFFF", 11);
        XWPFTableCell cellll111 = rowIndexaaaa10.getCell(1);
        cellll111.setText("");
        cellll111.setColor("5082bf");
        setCellStyle(cellll111, "行业参考值（范围）", true, "FFFFFF", 11);
        XWPFTableCell cellll112 = rowIndexaaaa10.getCell(2);
        cellll112.setText("");
        cellll112.setColor("5082bf");
        setCellStyle(cellll112, "偏差诊断及建议", true, "FFFFFF", 11);
        XWPFTableCell cellll113 = rowIndexaaaa10.getCell(3);
        cellll113.setText("");
        cellll113.setColor("5082bf");
        setCellStyle(cellll113, "AkzoNobel解决方案", true, "FFFFFF", 11);


        List<Object[]> list7 = vo.getEconomicDataReference();

        Object[] u1 = list7.get(0);
        Object[] u2 = list7.get(1);
        Object[] u3 = list7.get(2);
        Object[] u4 = list7.get(3);
        Object[] u5 = list7.get(4);
        Object[] u6 = list7.get(5);
        Object[] u7 = list7.get(6);

        XWPFTableRow rowIndexaaa11 = table4.getRow(1);
        XWPFTableCell cellll120 = rowIndexaaa11.getCell(0);
        cellll120.setText("");
        cellll120.setColor("5082bf");
        setCellStyle(cellll120, "返工率", true, "FFFFFF", 11);
        XWPFTableCell cellll121 = rowIndexaaa11.getCell(1);
        cellll121.setText("");
        cellll121.setColor("b8cce4");
        setCellStyle(cellll121, "<2%", false, "000000", 10);
        XWPFTableCell cellll122 = rowIndexaaa11.getCell(2);
        cellll122.setText("");
        cellll122.setColor("b8cce4");
        setCellStyle(cellll122, u1[2].toString(), false, "000000", 10);
        XWPFTableCell cellll123 = rowIndexaaa11.getCell(3);
        cellll123.setText("");
        cellll123.setColor("b8cce4");
        setCellStyle(cellll123, u1[3].toString(), false, "000000", 10);

        XWPFTableRow rowIndexaaa12 = table4.getRow(2);
        XWPFTableCell cellll130 = rowIndexaaa12.getCell(0);
        cellll130.setText("");
        cellll130.setColor("5082bf");
        setCellStyle(cellll130, "油漆成本占产值额比例", true, "FFFFFF", 11);
        XWPFTableCell cellll131 = rowIndexaaa12.getCell(1);
        cellll131.setText("");
        cellll131.setColor("dbe5f1");
        setCellStyle(cellll131, "", false, "000000", 10);
        XWPFTableCell cellll132 = rowIndexaaa12.getCell(2);
        cellll132.setText("");
        cellll132.setColor("dbe5f1");
        setCellStyle(cellll132, "", false, "000000", 10);
        XWPFTableCell cellll133 = rowIndexaaa12.getCell(3);
        cellll133.setText("");
        cellll133.setColor("dbe5f1");
        setCellStyle(cellll133, "", false, "000000", 10);

        XWPFTableRow rowIndexaaa13 = table4.getRow(3);
        XWPFTableCell cellll140 = rowIndexaaa13.getCell(0);
        cellll140.setText("");
        cellll140.setColor("5082bf");
        setCellStyle(cellll140, "人工成本占产值额比例", true, "FFFFFF", 11);
        XWPFTableCell cellll141 = rowIndexaaa13.getCell(1);
        cellll141.setText("");
        cellll141.setColor("b8cce4");
        setCellStyle(cellll141, "", false, "000000", 10);
        XWPFTableCell cellll142 = rowIndexaaa13.getCell(2);
        cellll142.setText("");
        cellll142.setColor("b8cce4");
        setCellStyle(cellll142, "", false, "000000", 10);
        XWPFTableCell cellll143 = rowIndexaaa13.getCell(3);
        cellll143.setText("");
        cellll143.setColor("b8cce4");
        setCellStyle(cellll143, "", false, "000000", 10);

        XWPFTableRow rowIndexaaa14 = table4.getRow(4);
        XWPFTableCell cellll150 = rowIndexaaa14.getCell(0);
        cellll150.setText("");
        cellll150.setColor("5082bf");
        setCellStyle(cellll150, "单面材料成本", true, "FFFFFF", 11);
        XWPFTableCell cellll151 = rowIndexaaa14.getCell(1);
        cellll151.setText("");
        cellll151.setColor("dbe5f1");
        setCellStyle(cellll151, "油性漆65～85；水性漆85～老白5", false, "000000", 10);
        XWPFTableCell cellll152 = rowIndexaaa14.getCell(2);
        cellll152.setText("");
        cellll152.setColor("dbe5f1");
        setCellStyle(cellll152, u4[2].toString(), false, "000000", 10);
        XWPFTableCell cellll153 = rowIndexaaa14.getCell(3);
        cellll153.setText("");
        cellll153.setColor("dbe5f1");
        setCellStyle(cellll153, u4[3].toString(), false, "000000", 10);

        XWPFTableRow rowIndexaaa15 = table4.getRow(5);
        XWPFTableCell cellll160 = rowIndexaaa15.getCell(0);
        cellll160.setText("");
        cellll160.setColor("5082bf");
        setCellStyle(cellll160, "单面人工成本", true, "FFFFFF", 11);
        XWPFTableCell cellll161 = rowIndexaaa15.getCell(1);
        cellll161.setText("");
        cellll161.setColor("b8cce4");
        setCellStyle(cellll161, "60～80/部件", false, "000000", 10);
        XWPFTableCell cellll162 = rowIndexaaa15.getCell(2);
        cellll162.setText("");
        cellll162.setColor("b8cce4");
        setCellStyle(cellll162, u5[2].toString(), false, "000000", 10);
        XWPFTableCell cellll163 = rowIndexaaa15.getCell(3);
        cellll163.setText("");
        cellll163.setColor("b8cce4");
        setCellStyle(cellll163, u5[3].toString(), false, "000000", 10);

        XWPFTableRow rowIndexaaa16 = table4.getRow(6);
        XWPFTableCell cellll170 = rowIndexaaa16.getCell(0);
        cellll170.setText("");
        cellll170.setColor("5082bf");
        setCellStyle(cellll170, "车间毛利", true, "FFFFFF", 11);
        XWPFTableCell cellll171 = rowIndexaaa16.getCell(1);
        cellll171.setText("");
        cellll171.setColor("dbe5f1");
        setCellStyle(cellll171, "", false, "000000", 10);
        XWPFTableCell cellll172 = rowIndexaaa16.getCell(2);
        cellll172.setText("");
        cellll172.setColor("dbe5f1");
        setCellStyle(cellll172, "", false, "000000", 10);
        XWPFTableCell cellll173 = rowIndexaaa16.getCell(3);
        cellll173.setText("");
        cellll173.setColor("dbe5f1");
        setCellStyle(cellll173, "", false, "000000", 10);

        XWPFTableRow rowIndexaaa17 = table4.getRow(7);
        XWPFTableCell cellll180 = rowIndexaaa17.getCell(0);
        cellll180.setText("");
        cellll180.setColor("5082bf");
        setCellStyle(cellll180, "车间毛利率", true, "FFFFFF", 11);
        XWPFTableCell cellll181 = rowIndexaaa17.getCell(1);
        cellll181.setText("");
        cellll181.setColor("b8cce4");
        setCellStyle(cellll181, "˃45%", false, "000000", 10);
        XWPFTableCell cellll182 = rowIndexaaa17.getCell(2);
        cellll182.setText("");
        cellll182.setColor("b8cce4");
        setCellStyle(cellll182, u7[2].toString(), false, "000000", 10);
        XWPFTableCell cellll183 = rowIndexaaa17.getCell(3);
        cellll183.setText("");
        cellll183.setColor("b8cce4");
        setCellStyle(cellll183, u7[3].toString(), false, "000000", 10);


        //添加标题
        XWPFParagraph titleParagraphhhhh1 = document.createParagraph();
        //设置段落居中
        titleParagraphhhhh1.setAlignment(ParagraphAlignment.LEFT);
        XWPFRun titleParagraphRunhhhh1 = titleParagraphhhhh1.createRun();
        titleParagraphRunhhhh1.setText("");
//        titleParagraphRun.setColor("000000");
        titleParagraphRunhhhh1.setFontSize(17);
        titleParagraphRunhhhh1.setFontFamily("微软雅黑");


        //创建表格
        int roww4 = 8;
        int columnn4 = 9;
        XWPFTable tablee4 = document.createTable(roww4, columnn4);
        setTableStyle(tablee4);
        setTableWidth(tablee4, "10000");
        //填充数据
        XWPFTableRow rowIndexxxxx10 = tablee4.getRow(0);
        XWPFTableCell cellllll10 = rowIndexxxxx10.getCell(0);
        cellllll10.setText("");
        cellllll10.setColor("5082bf");
        setCellStyle(cellllll10, "项目", true, "FFFFFF", 11);
        XWPFTableCell cellllll11 = rowIndexxxxx10.getCell(1);
        cellllll11.setText("");
        cellllll11.setColor("5082bf");
        setCellStyle(cellllll11, "改善前3个月", true, "FFFFFF", 11);
        XWPFTableCell cellllll12 = rowIndexxxxx10.getCell(2);
        cellllll12.setText("");
        cellllll12.setColor("5082bf");
        setCellStyle(cellllll12, "改善前2个月", true, "FFFFFF", 11);
        XWPFTableCell cellllll13 = rowIndexxxxx10.getCell(3);
        cellllll13.setText("");
        cellllll13.setColor("5082bf");
        setCellStyle(cellllll13, "改善前1个月", true, "FFFFFF", 11);
        XWPFTableCell cellllll14 = rowIndexxxxx10.getCell(4);
        cellllll14.setText("");
        cellllll14.setColor("5082bf");
        setCellStyle(cellllll14, "改善当月", true, "FFFFFF", 11);
        XWPFTableCell cellllll15 = rowIndexxxxx10.getCell(5);
        cellllll15.setText("");
        cellllll15.setColor("5082bf");
        setCellStyle(cellllll15, "改善后1个月", true, "FFFFFF", 11);
        XWPFTableCell cellllll16 = rowIndexxxxx10.getCell(6);
        cellllll16.setText("");
        cellllll16.setColor("5082bf");
        setCellStyle(cellllll16, "改善后2个月", true, "FFFFFF", 11);
        XWPFTableCell cellllll17 = rowIndexxxxx10.getCell(7);
        cellllll17.setText("");
        cellllll17.setColor("5082bf");
        setCellStyle(cellllll17, "改善后3个月", true, "FFFFFF", 11);
        XWPFTableCell cellllll18 = rowIndexxxxx10.getCell(8);
        cellllll18.setText("");
        cellllll18.setColor("5082bf");
        setCellStyle(cellllll18, "平均值", true, "FFFFFF", 11);

        List<Object[]> list4 = vo.getEconomicData();

        Object[] r1 = list4.get(0);
        Object[] r2 = list4.get(1);
        Object[] r3 = list4.get(2);
        Object[] r4 = list4.get(3);
        Object[] r5 = list4.get(4);
        Object[] r6 = list4.get(5);
        Object[] r7 = list4.get(6);
        Object[] r8 = list4.get(7);


        XWPFTableRow rowIndexxxxx11 = tablee4.getRow(1);
        XWPFTableCell cellllll20 = rowIndexxxxx11.getCell(0);
        cellllll20.setText("");
        cellllll20.setColor("5082bf");
        setCellStyle(cellllll20, "返工率", true, "FFFFFF", 11);
        XWPFTableCell cellllll21 = rowIndexxxxx11.getCell(1);
        cellllll21.setText("");
        cellllll21.setColor("b8cce4");
        setCellStyle(cellllll21, r1[1].toString(), false, "000000", 10);
        XWPFTableCell cellllll22 = rowIndexxxxx11.getCell(2);
        cellllll22.setText("");
        cellllll22.setColor("b8cce4");
        setCellStyle(cellllll22, r2[1].toString(), false, "000000", 10);
        XWPFTableCell cellllll23 = rowIndexxxxx11.getCell(3);
        cellllll23.setText("");
        cellllll23.setColor("b8cce4");
        setCellStyle(cellllll23, r3[1].toString(), false, "000000", 10);
        XWPFTableCell cellllll24 = rowIndexxxxx11.getCell(4);
        cellllll24.setText("");
        cellllll24.setColor("b8cce4");
        setCellStyle(cellllll24, r4[1].toString(), false, "000000", 10);
        XWPFTableCell cellllll25 = rowIndexxxxx11.getCell(5);
        cellllll25.setText("");
        cellllll25.setColor("b8cce4");
        setCellStyle(cellllll25, r5[1].toString(), false, "000000", 10);
        XWPFTableCell cellllll26 = rowIndexxxxx11.getCell(6);
        cellllll26.setText("");
        cellllll26.setColor("b8cce4");
        setCellStyle(cellllll26, r6[1].toString(), false, "000000", 10);
        XWPFTableCell cellllll27 = rowIndexxxxx11.getCell(7);
        cellllll27.setText("");
        cellllll27.setColor("b8cce4");
        setCellStyle(cellllll27, r7[1].toString(), false, "000000", 10);
        XWPFTableCell cellllll28 = rowIndexxxxx11.getCell(8);
        cellllll28.setText("");
        cellllll28.setColor("b8cce4");
        setCellStyle(cellllll28, r8[1].toString(), false, "000000", 10);

        XWPFTableRow rowIndexxxxx12 = tablee4.getRow(2);
        XWPFTableCell cellllll30 = rowIndexxxxx12.getCell(0);
        cellllll30.setText("");
        cellllll30.setColor("5082bf");
        setCellStyle(cellllll30, "油漆成本占产值额比例", true, "FFFFFF", 11);
        XWPFTableCell cellllll31 = rowIndexxxxx12.getCell(1);
        cellllll31.setText("");
        cellllll31.setColor("dbe5f1");
        setCellStyle(cellllll31, r1[2].toString(), false, "000000", 10);
        XWPFTableCell cellllll32 = rowIndexxxxx12.getCell(2);
        cellllll32.setText("");
        cellllll32.setColor("dbe5f1");
        setCellStyle(cellllll32, r2[2].toString(), false, "000000", 10);
        XWPFTableCell cellllll33 = rowIndexxxxx12.getCell(3);
        cellllll33.setText("");
        cellllll33.setColor("dbe5f1");
        setCellStyle(cellllll33, r3[2].toString(), false, "000000", 10);
        XWPFTableCell cellllll34 = rowIndexxxxx12.getCell(4);
        cellllll34.setText("");
        cellllll34.setColor("dbe5f1");
        setCellStyle(cellllll34, r4[2].toString(), false, "000000", 10);
        XWPFTableCell cellllll35 = rowIndexxxxx12.getCell(5);
        cellllll35.setText("");
        cellllll35.setColor("dbe5f1");
        setCellStyle(cellllll35, r5[2].toString(), false, "000000", 10);
        XWPFTableCell cellllll36 = rowIndexxxxx12.getCell(6);
        cellllll36.setText("");
        cellllll36.setColor("dbe5f1");
        setCellStyle(cellllll36, r6[2].toString(), false, "000000", 10);
        XWPFTableCell cellllll37 = rowIndexxxxx12.getCell(7);
        cellllll37.setText("");
        cellllll37.setColor("dbe5f1");
        setCellStyle(cellllll37, r7[2].toString(), false, "000000", 10);
        XWPFTableCell cellllll38 = rowIndexxxxx12.getCell(8);
        cellllll38.setText("");
        cellllll38.setColor("dbe5f1");
        setCellStyle(cellllll38, r8[2].toString(), false, "000000", 10);

        XWPFTableRow rowIndexxxxx13 = tablee4.getRow(3);
        XWPFTableCell cellllll40 = rowIndexxxxx13.getCell(0);
        cellllll40.setText("");
        cellllll40.setColor("5082bf");
        setCellStyle(cellllll40, "人工成本占产值额比例", true, "FFFFFF", 11);
        XWPFTableCell cellllll41 = rowIndexxxxx13.getCell(1);
        cellllll41.setText("");
        cellllll41.setColor("b8cce4");
        setCellStyle(cellllll41, r1[3].toString(), false, "000000", 10);
        XWPFTableCell cellllll42 = rowIndexxxxx13.getCell(2);
        cellllll42.setText("");
        cellllll42.setColor("b8cce4");
        setCellStyle(cellllll42, r2[3].toString(), false, "000000", 10);
        XWPFTableCell cellllll43 = rowIndexxxxx13.getCell(3);
        cellllll43.setText("");
        cellllll43.setColor("b8cce4");
        setCellStyle(cellllll43, r3[3].toString(), false, "000000", 10);
        XWPFTableCell cellllll44 = rowIndexxxxx13.getCell(4);
        cellllll44.setText("");
        cellllll44.setColor("b8cce4");
        setCellStyle(cellllll44, r4[3].toString(), false, "000000", 10);
        XWPFTableCell cellllll45 = rowIndexxxxx13.getCell(5);
        cellllll45.setText("");
        cellllll45.setColor("b8cce4");
        setCellStyle(cellllll45, r5[3].toString(), false, "000000", 10);
        XWPFTableCell cellllll46 = rowIndexxxxx13.getCell(6);
        cellllll46.setText("");
        cellllll46.setColor("b8cce4");
        setCellStyle(cellllll46, r6[3].toString(), false, "000000", 10);
        XWPFTableCell cellllll47 = rowIndexxxxx13.getCell(7);
        cellllll47.setText("");
        cellllll47.setColor("b8cce4");
        setCellStyle(cellllll47, r7[3].toString(), false, "000000", 10);
        XWPFTableCell cellllll48 = rowIndexxxxx13.getCell(8);
        cellllll48.setText("");
        cellllll48.setColor("b8cce4");
        setCellStyle(cellllll48, r8[3].toString(), false, "000000", 10);

        XWPFTableRow rowIndexxxxx14 = tablee4.getRow(4);
        XWPFTableCell cellllll50 = rowIndexxxxx14.getCell(0);
        cellllll50.setText("");
        cellllll50.setColor("5082bf");
        setCellStyle(cellllll50, "单面材料成本", true, "FFFFFF", 11);
        XWPFTableCell cellllll51 = rowIndexxxxx14.getCell(1);
        cellllll51.setText("");
        cellllll51.setColor("dbe5f1");
        setCellStyle(cellllll51, r1[4].toString(), false, "000000", 10);
        XWPFTableCell cellllll52 = rowIndexxxxx14.getCell(2);
        cellllll52.setText("");
        cellllll52.setColor("dbe5f1");
        setCellStyle(cellllll52, r2[4].toString(), false, "000000", 10);
        XWPFTableCell cellllll53 = rowIndexxxxx14.getCell(3);
        cellllll53.setText("");
        cellllll53.setColor("dbe5f1");
        setCellStyle(cellllll53, r3[4].toString(), false, "000000", 10);
        XWPFTableCell cellllll54 = rowIndexxxxx14.getCell(4);
        cellllll54.setText("");
        cellllll54.setColor("dbe5f1");
        setCellStyle(cellllll54, r4[4].toString(), false, "000000", 10);
        XWPFTableCell cellllll55 = rowIndexxxxx14.getCell(5);
        cellllll55.setText("");
        cellllll55.setColor("dbe5f1");
        setCellStyle(cellllll55, r5[4].toString(), false, "000000", 10);
        XWPFTableCell cellllll56 = rowIndexxxxx14.getCell(6);
        cellllll56.setText("");
        cellllll56.setColor("dbe5f1");
        setCellStyle(cellllll56, r6[4].toString(), false, "000000", 10);
        XWPFTableCell cellllll57 = rowIndexxxxx14.getCell(7);
        cellllll57.setText("");
        cellllll57.setColor("dbe5f1");
        setCellStyle(cellllll57, r7[4].toString(), false, "000000", 10);
        XWPFTableCell cellllll58 = rowIndexxxxx14.getCell(8);
        cellllll58.setText("");
        cellllll58.setColor("dbe5f1");
        setCellStyle(cellllll58, r8[4].toString(), false, "000000", 10);

        XWPFTableRow rowIndexxxxx15 = tablee4.getRow(5);
        XWPFTableCell cellllll60 = rowIndexxxxx15.getCell(0);
        cellllll60.setText("");
        cellllll60.setColor("5082bf");
        setCellStyle(cellllll60, "单面人工成本", true, "FFFFFF", 11);
        XWPFTableCell cellllll61 = rowIndexxxxx15.getCell(1);
        cellllll61.setText("");
        cellllll61.setColor("b8cce4");
        setCellStyle(cellllll61, r1[5].toString(), false, "000000", 10);
        XWPFTableCell cellllll62 = rowIndexxxxx15.getCell(2);
        cellllll62.setText("");
        cellllll62.setColor("b8cce4");
        setCellStyle(cellllll62, r2[5].toString(), false, "000000", 10);
        XWPFTableCell cellllll63 = rowIndexxxxx15.getCell(3);
        cellllll63.setText("");
        cellllll63.setColor("b8cce4");
        setCellStyle(cellllll63, r3[5].toString(), false, "000000", 10);
        XWPFTableCell cellllll64 = rowIndexxxxx15.getCell(4);
        cellllll64.setText("");
        cellllll64.setColor("b8cce4");
        setCellStyle(cellllll64, r4[5].toString(), false, "000000", 10);
        XWPFTableCell cellllll65 = rowIndexxxxx15.getCell(5);
        cellllll65.setText("");
        cellllll65.setColor("b8cce4");
        setCellStyle(cellllll65, r5[5].toString(), false, "000000", 10);
        XWPFTableCell cellllll66 = rowIndexxxxx15.getCell(6);
        cellllll66.setText("");
        cellllll66.setColor("b8cce4");
        setCellStyle(cellllll66, r6[5].toString(), false, "000000", 10);
        XWPFTableCell cellllll67 = rowIndexxxxx15.getCell(7);
        cellllll67.setText("");
        cellllll67.setColor("b8cce4");
        setCellStyle(cellllll67, r7[5].toString(), false, "000000", 10);
        XWPFTableCell cellllll68 = rowIndexxxxx15.getCell(8);
        cellllll68.setText("");
        cellllll68.setColor("b8cce4");
        setCellStyle(cellllll68, r8[5].toString(), false, "000000", 10);

        XWPFTableRow rowIndexxxxx16 = tablee4.getRow(6);
        XWPFTableCell cellllll70 = rowIndexxxxx16.getCell(0);
        cellllll70.setText("");
        cellllll70.setColor("5082bf");
        setCellStyle(cellllll70, "车间毛利", true, "FFFFFF", 11);
        XWPFTableCell cellllll71 = rowIndexxxxx16.getCell(1);
        cellllll71.setText("");
        cellllll71.setColor("dbe5f1");
        setCellStyle(cellllll71, r1[6].toString(), false, "000000", 10);
        XWPFTableCell cellllll72 = rowIndexxxxx16.getCell(2);
        cellllll72.setText("");
        cellllll72.setColor("dbe5f1");
        setCellStyle(cellllll72, r2[6].toString(), false, "000000", 10);
        XWPFTableCell cellllll73 = rowIndexxxxx16.getCell(3);
        cellllll73.setText("");
        cellllll73.setColor("dbe5f1");
        setCellStyle(cellllll73, r3[6].toString(), false, "000000", 10);
        XWPFTableCell cellllll74 = rowIndexxxxx16.getCell(4);
        cellllll74.setText("");
        cellllll74.setColor("dbe5f1");
        setCellStyle(cellllll74, r4[6].toString(), false, "000000", 10);
        XWPFTableCell cellllll75 = rowIndexxxxx16.getCell(5);
        cellllll75.setText("");
        cellllll75.setColor("dbe5f1");
        setCellStyle(cellllll75, r5[6].toString(), false, "000000", 10);
        XWPFTableCell cellllll76 = rowIndexxxxx16.getCell(6);
        cellllll76.setText("");
        cellllll76.setColor("dbe5f1");
        setCellStyle(cellllll76, r6[6].toString(), false, "000000", 10);
        XWPFTableCell cellllll77 = rowIndexxxxx16.getCell(7);
        cellllll77.setText("");
        cellllll77.setColor("dbe5f1");
        setCellStyle(cellllll77, r7[6].toString(), false, "000000", 10);
        XWPFTableCell cellllll78 = rowIndexxxxx16.getCell(8);
        cellllll78.setText("");
        cellllll78.setColor("dbe5f1");
        setCellStyle(cellllll78, r8[6].toString(), false, "000000", 10);

        XWPFTableRow rowIndexxxxx17 = tablee4.getRow(7);
        XWPFTableCell cellllll80 = rowIndexxxxx17.getCell(0);
        cellllll80.setText("");
        cellllll80.setColor("5082bf");
        setCellStyle(cellllll80, "车间毛利率", true, "FFFFFF", 11);
        XWPFTableCell cellllll81 = rowIndexxxxx17.getCell(1);
        cellllll81.setText("");
        cellllll81.setColor("b8cce4");
        setCellStyle(cellllll81, r1[7].toString(), false, "000000", 10);
        XWPFTableCell cellllll82 = rowIndexxxxx17.getCell(2);
        cellllll82.setText("");
        cellllll82.setColor("b8cce4");
        setCellStyle(cellllll82, r2[7].toString(), false, "000000", 10);
        XWPFTableCell cellllll83 = rowIndexxxxx17.getCell(3);
        cellllll83.setText("");
        cellllll83.setColor("b8cce4");
        setCellStyle(cellllll83, r3[7].toString(), false, "000000", 10);
        XWPFTableCell cellllll84 = rowIndexxxxx17.getCell(4);
        cellllll84.setText("");
        cellllll84.setColor("b8cce4");
        setCellStyle(cellllll84, r4[7].toString(), false, "000000", 10);
        XWPFTableCell cellllll85 = rowIndexxxxx17.getCell(5);
        cellllll85.setText("");
        cellllll85.setColor("b8cce4");
        setCellStyle(cellllll85, r5[7].toString(), false, "000000", 10);
        XWPFTableCell cellllll86 = rowIndexxxxx17.getCell(6);
        cellllll86.setText("");
        cellllll86.setColor("b8cce4");
        setCellStyle(cellllll86, r6[7].toString(), false, "000000", 10);
        XWPFTableCell cellllll87 = rowIndexxxxx17.getCell(7);
        cellllll87.setText("");
        cellllll87.setColor("b8cce4");
        setCellStyle(cellllll87, r7[7].toString(), false, "000000", 10);
        XWPFTableCell cellllll88 = rowIndexxxxx17.getCell(8);
        cellllll88.setText("");
        cellllll88.setColor("b8cce4");
        setCellStyle(cellllll88, r8[7].toString(), false, "000000", 10);


        fileInputStream.close();
//        for(int i = 2,ii=1;i<row-1;i++,ii++){
//            XWPFTableRow rowIndex2 = table.getRow(i);
//            for(int j = 0,jj=0;j<column-1 ;j++){
//                XWPFTableCell cell4 =null;
//                if(j==0){
//                    cell4 =rowIndex2.getCell(j);
//                    cell4.setText(list[ii][jj]);
//                    jj++;
//                }if(j==2){
//                    cell4 =rowIndex2.getCell(j);
//                    cell4.setText(list[ii][jj]);
//                    jj++;
//                }else if(j>=5){
//                    cell4 =rowIndex2.getCell(j);
//                    cell4.setText(list[ii][jj]);
//                    jj++;
//                }
//            }
//        }

        List<String> svgTitleList = new ArrayList<>();
        svgTitleList.add("总结分析-关键KPI指标-维修产值（上涨）");
        svgTitleList.add("总结分析-关键KPI指标-维修台次（上涨）");
        svgTitleList.add("总结分析-关键KPI指标");
        svgTitleList.add("总结分析-关键KPI指标-成本");
        svgTitleList.add("总结分析-关键KPI指标-返工率");
        svgTitleList.add("总结分析-关键KPI指标-毛利率");

        List<String> svgList = vo.getResponseKpi();
        if (null != svgList && svgList.size() > 0) {
            int i = 0;
            for (String svg : svgList) {
                XWPFParagraph pargraphTitle = document.createParagraph();
                pargraphTitle.setAlignment(ParagraphAlignment.CENTER);
                XWPFRun runTitle = pargraphTitle.createRun();
                runTitle.setText(svgTitleList.get(i));
                runTitle.setFontSize(17);
                runTitle.setFontFamily("微软雅黑");

                XWPFParagraph pargraph = document.createParagraph();
                XWPFRun run = pargraph.createRun();
                ByteArrayOutputStream baossvg = new ByteArrayOutputStream();
                WordUtil.convertToPng(svg, baossvg);
                String path = "E:\\" + i + "svg.png";
                WordUtil.convertToPng(svg, path);

                try {
                    ByteArrayInputStream swapStream = new ByteArrayInputStream(baossvg.toByteArray());
                    if(i < 4) {
                        run.addPicture(swapStream, CustomXWPFDocument.PICTURE_TYPE_PNG, "svg.png", Units.toEMU(500), Units.toEMU(250));
                    } else {
                        run.addPicture(swapStream, CustomXWPFDocument.PICTURE_TYPE_PNG, "svg.png", Units.toEMU(500), Units.toEMU(375));
                    }
                } catch (Exception e) {
                    e.printStackTrace();
                }
                baossvg.close();
                i++;
            }
        }

//        //创建表格
//        int roww5 = 1;
//        int columnn5 = 1;
//        XWPFTable tablee5 = document.createTable(roww5,columnn5);
//
//        setTableWidth(tablee5, "10000");
//        XWPFTableRow rowIndexxxxxx10 = tablee5.getRow(0);
//        XWPFTableCell celllllll10 = rowIndexxxxxx10.getCell(0);
////        cellllll10.setText("项目");
//        ByteArrayOutputStream baossvg = new ByteArrayOutputStream();
//        WordUtil.convertToPng("<svg version='1.1' class='highcharts-root' style='font-family:&quot;Lucida Grande&quot;, &quot;Lucida Sans Unicode&quot;, Arial, Helvetica, sans-serif;font-size:12px;' xmlns='http://www.w3.org/2000/svg' width='634' height='400' viewBox='0 0 634 400'><desc>Created with Highcharts 6.1.1</desc><defs><clipPath id='highcharts-1pwty3v-21'><rect x='0' y='0' width='550' height='353' fill='none'></rect></clipPath></defs><rect fill='#ffffff' class='highcharts-background' x='0' y='0' width='634' height='400' rx='0' ry='0'></rect><rect fill='none' class='highcharts-plot-background' x='74' y='10' width='550' height='353'></rect><g class='highcharts-grid highcharts-xaxis-grid ' data-z-index='1'><path fill='none' data-z-index='1' class='highcharts-grid-line' d='M 348.5 10 L 348.5 363' opacity='1'></path><path fill='none' data-z-index='1' class='highcharts-grid-line' d='M 623.5 10 L 623.5 363' opacity='1'></path><path fill='none' data-z-index='1' class='highcharts-grid-line' d='M 73.5 10 L 73.5 363' opacity='1'></path></g><g class='highcharts-grid highcharts-yaxis-grid ' data-z-index='1'><path fill='none' stroke='#e6e6e6' stroke-width='1' data-z-index='1' class='highcharts-grid-line' d='M 74 363.5 L 624 363.5' opacity='1'></path><path fill='none' stroke='#e6e6e6' stroke-width='1' data-z-index='1' class='highcharts-grid-line' d='M 74 292.5 L 624 292.5' opacity='1'></path><path fill='none' stroke='#e6e6e6' stroke-width='1' data-z-index='1' class='highcharts-grid-line' d='M 74 222.5 L 624 222.5' opacity='1'></path><path fill='none' stroke='#e6e6e6' stroke-width='1' data-z-index='1' class='highcharts-grid-line' d='M 74 151.5 L 624 151.5' opacity='1'></path><path fill='none' stroke='#e6e6e6' stroke-width='1' data-z-index='1' class='highcharts-grid-line' d='M 74 81.5 L 624 81.5' opacity='1'></path><path fill='none' stroke='#e6e6e6' stroke-width='1' data-z-index='1' class='highcharts-grid-line' d='M 74 9.5 L 624 9.5' opacity='1'></path></g><rect fill='none' class='highcharts-plot-border' data-z-index='1' x='74' y='10' width='550' height='353'></rect><g class='highcharts-axis highcharts-xaxis ' data-z-index='2'><path fill='none' class='highcharts-tick' stroke='#ccd6eb' stroke-width='1' d='M 348.5 363 L 348.5 373' opacity='1'></path><path fill='none' class='highcharts-tick' stroke='#ccd6eb' stroke-width='1' d='M 624.5 363 L 624.5 373' opacity='1'></path><path fill='none' class='highcharts-tick' stroke='#ccd6eb' stroke-width='1' d='M 73.5 363 L 73.5 373' opacity='1'></path><path fill='none' class='highcharts-axis-line' stroke='#ccd6eb' stroke-width='1' data-z-index='7' d='M 74 363.5 L 624 363.5'></path></g><g class='highcharts-axis highcharts-yaxis ' data-z-index='2'><text x='26.09375' data-z-index='7' text-anchor='middle' transform='translate(0,0) rotate(270 26.09375 186.5)' class='highcharts-axis-title' style='color:#666666;fill:#666666;' y='186.5'><tspan>维修产值</tspan></text><path fill='none' class='highcharts-axis-line' data-z-index='7' d='M 74 10 L 74 363'></path></g><g class='highcharts-series-group' data-z-index='3'><g data-z-index='0.1' class='highcharts-series highcharts-series-0 highcharts-column-series highcharts-color-0 highcharts-tracker' transform='translate(74,10) scale(1 1)' clip-path='url(#highcharts-1pwty3v-21)'><rect x='122.5' y='28.5' width='30' height='325' fill='#7cb5ec' stroke='#ffffff' stroke-width='1' class='highcharts-point highcharts-color-0'></rect><rect x='397.5' y='28.5' width='30' height='325' fill='#7cb5ec' stroke='#ffffff' stroke-width='1' class='highcharts-point highcharts-color-0'></rect></g><g data-z-index='0.1' class='highcharts-markers highcharts-series-0 highcharts-column-series highcharts-color-0 ' transform='translate(74,10) scale(1 1)' clip-path='none'></g></g><text x='317' text-anchor='middle' class='highcharts-title' data-z-index='4' style='color:#333333;font-size:18px;fill:#333333;' y='24'></text><text x='317' text-anchor='middle' class='highcharts-subtitle' data-z-index='4' style='color:#666666;fill:#666666;' y='24'></text><g class='highcharts-axis-labels highcharts-xaxis-labels ' data-z-index='7'><text x='211.5' style='color:#666666;cursor:default;font-size:11px;fill:#666666;' text-anchor='middle' transform='translate(0,0)' y='382' opacity='1'>改善前1个月</text><text x='486.5' style='color:#666666;cursor:default;font-size:11px;fill:#666666;' text-anchor='middle' transform='translate(0,0)' y='382' opacity='1'>改善当月</text></g><g class='highcharts-axis-labels highcharts-yaxis-labels ' data-z-index='7'><text x='59' style='color:#666666;cursor:default;font-size:11px;fill:#666666;' text-anchor='end' transform='translate(0,0)' y='367' opacity='1'>0</text><text x='59' style='color:#666666;cursor:default;font-size:11px;fill:#666666;' text-anchor='end' transform='translate(0,0)' y='296' opacity='1'>50</text><text x='59' style='color:#666666;cursor:default;font-size:11px;fill:#666666;' text-anchor='end' transform='translate(0,0)' y='226' opacity='1'>100</text><text x='59' style='color:#666666;cursor:default;font-size:11px;fill:#666666;' text-anchor='end' transform='translate(0,0)' y='155' opacity='1'>150</text><text x='59' style='color:#666666;cursor:default;font-size:11px;fill:#666666;' text-anchor='end' transform='translate(0,0)' y='85' opacity='1'>200</text><text x='59' style='color:#666666;cursor:default;font-size:11px;fill:#666666;' text-anchor='end' transform='translate(0,0)' y='14' opacity='1'>250</text></g></svg>", baossvg);
//        XWPFParagraph pargraph = celllllll10.addParagraph();
//        try {
//            ByteArrayInputStream swapStream = new ByteArrayInputStream(baossvg.toByteArray());
//            XWPFRun run = pargraph.createRun();
//            run.addPicture(swapStream, CustomXWPFDocument.PICTURE_TYPE_PNG, "svg.png", Units.toEMU(500) , Units.toEMU(300));
////            int ind = document.addPicture(baossvg.toByteArray(),CustomXWPFDocument.PICTURE_TYPE_PNG);
////            document.createPicture(ind, 50 , 50,pargraph);
//        } catch (Exception e) {
//            e.printStackTrace();
//        }
//        baossvg.close();

//        ByteArrayOutputStream baossvg = new ByteArrayOutputStream();
//        WordUtil.convertToPng("<svg version='1.1' class='highcharts-root' style='font-family:&quot;Lucida Grande&quot;, &quot;Lucida Sans Unicode&quot;, Arial, Helvetica, sans-serif;font-size:12px;' xmlns='http://www.w3.org/2000/svg' width='634' height='400' viewBox='0 0 634 400'><desc>Created with Highcharts 6.1.1</desc><defs><clipPath id='highcharts-1pwty3v-21'><rect x='0' y='0' width='550' height='353' fill='none'></rect></clipPath></defs><rect fill='#ffffff' class='highcharts-background' x='0' y='0' width='634' height='400' rx='0' ry='0'></rect><rect fill='none' class='highcharts-plot-background' x='74' y='10' width='550' height='353'></rect><g class='highcharts-grid highcharts-xaxis-grid ' data-z-index='1'><path fill='none' data-z-index='1' class='highcharts-grid-line' d='M 348.5 10 L 348.5 363' opacity='1'></path><path fill='none' data-z-index='1' class='highcharts-grid-line' d='M 623.5 10 L 623.5 363' opacity='1'></path><path fill='none' data-z-index='1' class='highcharts-grid-line' d='M 73.5 10 L 73.5 363' opacity='1'></path></g><g class='highcharts-grid highcharts-yaxis-grid ' data-z-index='1'><path fill='none' stroke='#e6e6e6' stroke-width='1' data-z-index='1' class='highcharts-grid-line' d='M 74 363.5 L 624 363.5' opacity='1'></path><path fill='none' stroke='#e6e6e6' stroke-width='1' data-z-index='1' class='highcharts-grid-line' d='M 74 292.5 L 624 292.5' opacity='1'></path><path fill='none' stroke='#e6e6e6' stroke-width='1' data-z-index='1' class='highcharts-grid-line' d='M 74 222.5 L 624 222.5' opacity='1'></path><path fill='none' stroke='#e6e6e6' stroke-width='1' data-z-index='1' class='highcharts-grid-line' d='M 74 151.5 L 624 151.5' opacity='1'></path><path fill='none' stroke='#e6e6e6' stroke-width='1' data-z-index='1' class='highcharts-grid-line' d='M 74 81.5 L 624 81.5' opacity='1'></path><path fill='none' stroke='#e6e6e6' stroke-width='1' data-z-index='1' class='highcharts-grid-line' d='M 74 9.5 L 624 9.5' opacity='1'></path></g><rect fill='none' class='highcharts-plot-border' data-z-index='1' x='74' y='10' width='550' height='353'></rect><g class='highcharts-axis highcharts-xaxis ' data-z-index='2'><path fill='none' class='highcharts-tick' stroke='#ccd6eb' stroke-width='1' d='M 348.5 363 L 348.5 373' opacity='1'></path><path fill='none' class='highcharts-tick' stroke='#ccd6eb' stroke-width='1' d='M 624.5 363 L 624.5 373' opacity='1'></path><path fill='none' class='highcharts-tick' stroke='#ccd6eb' stroke-width='1' d='M 73.5 363 L 73.5 373' opacity='1'></path><path fill='none' class='highcharts-axis-line' stroke='#ccd6eb' stroke-width='1' data-z-index='7' d='M 74 363.5 L 624 363.5'></path></g><g class='highcharts-axis highcharts-yaxis ' data-z-index='2'><text x='26.09375' data-z-index='7' text-anchor='middle' transform='translate(0,0) rotate(270 26.09375 186.5)' class='highcharts-axis-title' style='color:#666666;fill:#666666;' y='186.5'><tspan>维修产值</tspan></text><path fill='none' class='highcharts-axis-line' data-z-index='7' d='M 74 10 L 74 363'></path></g><g class='highcharts-series-group' data-z-index='3'><g data-z-index='0.1' class='highcharts-series highcharts-series-0 highcharts-column-series highcharts-color-0 highcharts-tracker' transform='translate(74,10) scale(1 1)' clip-path='url(#highcharts-1pwty3v-21)'><rect x='122.5' y='28.5' width='30' height='325' fill='#7cb5ec' stroke='#ffffff' stroke-width='1' class='highcharts-point highcharts-color-0'></rect><rect x='397.5' y='28.5' width='30' height='325' fill='#7cb5ec' stroke='#ffffff' stroke-width='1' class='highcharts-point highcharts-color-0'></rect></g><g data-z-index='0.1' class='highcharts-markers highcharts-series-0 highcharts-column-series highcharts-color-0 ' transform='translate(74,10) scale(1 1)' clip-path='none'></g></g><text x='317' text-anchor='middle' class='highcharts-title' data-z-index='4' style='color:#333333;font-size:18px;fill:#333333;' y='24'></text><text x='317' text-anchor='middle' class='highcharts-subtitle' data-z-index='4' style='color:#666666;fill:#666666;' y='24'></text><g class='highcharts-axis-labels highcharts-xaxis-labels ' data-z-index='7'><text x='211.5' style='color:#666666;cursor:default;font-size:11px;fill:#666666;' text-anchor='middle' transform='translate(0,0)' y='382' opacity='1'>改善前1个月</text><text x='486.5' style='color:#666666;cursor:default;font-size:11px;fill:#666666;' text-anchor='middle' transform='translate(0,0)' y='382' opacity='1'>改善当月</text></g><g class='highcharts-axis-labels highcharts-yaxis-labels ' data-z-index='7'><text x='59' style='color:#666666;cursor:default;font-size:11px;fill:#666666;' text-anchor='end' transform='translate(0,0)' y='367' opacity='1'>0</text><text x='59' style='color:#666666;cursor:default;font-size:11px;fill:#666666;' text-anchor='end' transform='translate(0,0)' y='296' opacity='1'>50</text><text x='59' style='color:#666666;cursor:default;font-size:11px;fill:#666666;' text-anchor='end' transform='translate(0,0)' y='226' opacity='1'>100</text><text x='59' style='color:#666666;cursor:default;font-size:11px;fill:#666666;' text-anchor='end' transform='translate(0,0)' y='155' opacity='1'>150</text><text x='59' style='color:#666666;cursor:default;font-size:11px;fill:#666666;' text-anchor='end' transform='translate(0,0)' y='85' opacity='1'>200</text><text x='59' style='color:#666666;cursor:default;font-size:11px;fill:#666666;' text-anchor='end' transform='translate(0,0)' y='14' opacity='1'>250</text></g></svg>", baossvg);
//        Map<String,Object> svg1 = new HashMap<String, Object>();
//        svg1.put("width", 900);
//        svg1.put("height", 300);
//        svg1.put("type", "png");
//        svg1.put("content", baossvg.toByteArray());
//        param.put("Svg1",svg1);

//        XWPFParagraph pargraph = cellllll10.addParagraph();
//        if("笑脸".equals(a[5].toString())) {
//            try {
//                int ind = document.addPicture(streamHappy,CustomXWPFDocument.PICTURE_TYPE_PNG);
//                document.createPicture(ind, 50 , 50,pargraph);
//            } catch (Exception e) {
//                e.printStackTrace();
//            }
//        } else {
//            try {
//                int ind = document.addPicture(streamAlert,CustomXWPFDocument.PICTURE_TYPE_PNG);
//                document.createPicture(ind, 50 , 50,pargraph);
//            } catch (Exception e) {
//                e.printStackTrace();
//            }
//        }

        OutputStream output = new FileOutputStream(filePath);
        document.write(output);
        output.close();
    }


    public static void exportWeekKpiToWord(VstarUserKpiReport vstarUserKpiReport, String filePath, String templetPath) throws IOException {
        FileInputStream fileInputStream = new FileInputStream(filePath);
        CustomXWPFDocument document = new CustomXWPFDocument(fileInputStream);
        List<VstarUserKpiReport_Complete> completeList = vstarUserKpiReport.getVstarUserKpiReport_complete();
        List<VstarUserKpiReport_NeedFollowUp> followUpList = vstarUserKpiReport.getVstarUserKpiReport_needFollowUp();
        List<VstarUserKpiReport_Plan> planList = vstarUserKpiReport.getVstarUserKpiReport_Plan();


        //添加标题
        XWPFParagraph titleParagraphh1 = document.createParagraph();
        //设置段落居中
        titleParagraphh1.setAlignment(ParagraphAlignment.CENTER);
        XWPFRun titleParagraphRunh1 = titleParagraphh1.createRun();
        titleParagraphRunh1.setText("报告详情统计");
        titleParagraphRunh1.setFontSize(17);
        titleParagraphRunh1.setFontFamily("微软雅黑");

        if (null != completeList && completeList.size() > 0) {
            //创建表格
            int row = completeList.size() + 1;
            int column = 14;
            XWPFTable table = document.createTable(row, column);
            XWPFTableRow rowIndex10 = table.getRow(0);
            XWPFTableCell cell10 = rowIndex10.getCell(0);
            cell10.setText("日期");
            XWPFTableCell cell11 = rowIndex10.getCell(1);
            cell11.setText("工作人员");
            XWPFTableCell cell12 = rowIndex10.getCell(2);
            cell12.setText("所属省份");
            XWPFTableCell cell13 = rowIndex10.getCell(3);
            cell13.setText("客户名称");
            XWPFTableCell cell15 = rowIndex10.getCell(4);
            cell15.setText("维修站类型");
            XWPFTableCell cell16 = rowIndex10.getCell(5);
            cell16.setText("具体品牌");
            XWPFTableCell cell17 = rowIndex10.getCell(6);
            cell17.setText("客户代码");
            XWPFTableCell cell18 = rowIndex10.getCell(7);
            cell18.setText("客户状态");
            XWPFTableCell cell19 = rowIndex10.getCell(8);
            cell19.setText("客户类型");
            XWPFTableCell cell20 = rowIndex10.getCell(9);
            cell20.setText("油漆品牌");
            XWPFTableCell cell21 = rowIndex10.getCell(10);
            cell21.setText("品牌定位");
            XWPFTableCell cell22 = rowIndex10.getCell(11);
            cell22.setText("服务商");
            XWPFTableCell cell23 = rowIndex10.getCell(12);
            cell23.setText("重点工作分类");
            XWPFTableCell cell24 = rowIndex10.getCell(13);
            cell24.setText("服务自我评估");
            ExportWordUtil.setTableWidth(table, "13000");

            int i = 1;
            for (VstarUserKpiReport_Complete complete : completeList) {
                //填充数据
                XWPFTableRow rowIndex = table.getRow(i);
                XWPFTableCell cell1 = rowIndex.getCell(0);
                cell1.setText(complete.getTime());
                XWPFTableCell cell2 = rowIndex.getCell(1);
                cell2.setText(complete.getWorkUser());
                XWPFTableCell cell3 = rowIndex.getCell(2);
                cell3.setText(complete.getProvince());
                XWPFTableCell cell4 = rowIndex.getCell(3);
                cell4.setText(complete.getCustomerName());
                XWPFTableCell cell5 = rowIndex.getCell(4);
                cell5.setText(complete.getCategory());

                XWPFTableCell cell6 = rowIndex.getCell(5);
                cell6.setText(complete.getBrand());
                XWPFTableCell cell7 = rowIndex.getCell(6);
                cell7.setText(complete.getStationNum());
                XWPFTableCell cell8 = rowIndex.getCell(7);
                cell8.setText(complete.getCustomerStat());
                XWPFTableCell cell9 = rowIndex.getCell(8);
                cell9.setText(complete.getCustomerType());
                cell10 = rowIndex.getCell(9);
                cell10.setText(complete.getPaintBrand());
                cell11 = rowIndex.getCell(10);
                cell11.setText(complete.getProduct_position());
                cell12 = rowIndex.getCell(11);
                cell12.setText(complete.getServiceCompany());
                cell13 = rowIndex.getCell(12);
                cell13.setText(complete.getWorkType());
                XWPFTableCell cell14 = rowIndex.getCell(13);
                cell14.setText(complete.getServicePoint());
                i++;
            }
        }


        if (null != followUpList && followUpList.size() > 0) {
            //添加标题
            titleParagraphh1 = document.createParagraph();
            //设置段落居中
            titleParagraphh1.setAlignment(ParagraphAlignment.CENTER);
            titleParagraphRunh1 = titleParagraphh1.createRun();
            titleParagraphRunh1.setText("异常报告");
            titleParagraphRunh1.setFontSize(17);
            titleParagraphRunh1.setFontFamily("微软雅黑");
            //创建表格
            int row = followUpList.size() + 1;
            int column = 14;
            XWPFTable table = document.createTable(row, column);
            XWPFTableRow rowIndex10 = table.getRow(0);
            XWPFTableCell cell10 = rowIndex10.getCell(0);
            cell10.setText("日期");
            XWPFTableCell cell11 = rowIndex10.getCell(1);
            cell11.setText("工作人员");
            XWPFTableCell cell12 = rowIndex10.getCell(2);
            cell12.setText("所属省份");
            XWPFTableCell cell13 = rowIndex10.getCell(3);
            cell13.setText("客户名称");
            XWPFTableCell cell15 = rowIndex10.getCell(4);
            cell15.setText("维修站类型");
            XWPFTableCell cell16 = rowIndex10.getCell(5);
            cell16.setText("具体品牌");
            XWPFTableCell cell17 = rowIndex10.getCell(6);
            cell17.setText("客户代码");
            XWPFTableCell cell18 = rowIndex10.getCell(7);
            cell18.setText("客户状态");
            XWPFTableCell cell19 = rowIndex10.getCell(8);
            cell19.setText("客户类型");
            XWPFTableCell cell20 = rowIndex10.getCell(9);
            cell20.setText("油漆品牌");
            XWPFTableCell cell21 = rowIndex10.getCell(10);
            cell21.setText("品牌定位");
            XWPFTableCell cell22 = rowIndex10.getCell(11);
            cell22.setText("服务商");
            XWPFTableCell cell23 = rowIndex10.getCell(12);
            cell23.setText("重点工作分类");
            XWPFTableCell cell24 = rowIndex10.getCell(13);
            cell24.setText("服务自我评估");
            ExportWordUtil.setTableWidth(table, "13000");

            int i = 1;
            for (VstarUserKpiReport_NeedFollowUp followUp : followUpList) {
                //填充数据
                XWPFTableRow rowIndex = table.getRow(i);
                XWPFTableCell cell1 = rowIndex.getCell(0);
                cell1.setText(followUp.getDateTime());
                XWPFTableCell cell2 = rowIndex.getCell(1);
                cell2.setText(followUp.getWorkUser());
                XWPFTableCell cell3 = rowIndex.getCell(2);
                cell3.setText(followUp.getProvince());
                XWPFTableCell cell4 = rowIndex.getCell(3);
                cell4.setText(followUp.getCuntomerName());
                XWPFTableCell cell5 = rowIndex.getCell(4);
                cell5.setText(followUp.getCategory());

                XWPFTableCell cell6 = rowIndex.getCell(5);
                cell6.setText(followUp.getBrand());
                XWPFTableCell cell7 = rowIndex.getCell(6);
                cell7.setText(followUp.getStationNum());
                XWPFTableCell cell8 = rowIndex.getCell(7);
                cell8.setText(followUp.getCustomerStat());
                XWPFTableCell cell9 = rowIndex.getCell(8);
                cell9.setText(followUp.getCustomerType());
                cell10 = rowIndex.getCell(9);
                cell10.setText(followUp.getPaintBrand());
                cell11 = rowIndex.getCell(10);
                cell11.setText(followUp.getProduct_position());
                cell12 = rowIndex.getCell(11);
                cell12.setText(followUp.getServiceCompany());
                cell13 = rowIndex.getCell(12);
                cell13.setText(followUp.getWorkType());
                XWPFTableCell cell14 = rowIndex.getCell(13);
                cell14.setText(followUp.getServicePoint());
                i++;
            }
        }


        if (null != planList && planList.size() > 0) {
            //添加标题
            titleParagraphh1 = document.createParagraph();
            //设置段落居中
            titleParagraphh1.setAlignment(ParagraphAlignment.CENTER);
            titleParagraphRunh1 = titleParagraphh1.createRun();
            titleParagraphRunh1.setText("下周计划");
            titleParagraphRunh1.setFontSize(17);
            titleParagraphRunh1.setFontFamily("微软雅黑");
            //创建表格
            //创建表格
            int row = planList.size() + 1;
            int column = 14;
            XWPFTable table = document.createTable(row, column);
            XWPFTableRow rowIndex10 = table.getRow(0);
            XWPFTableCell cell10 = rowIndex10.getCell(0);
            cell10.setText("日期");
            XWPFTableCell cell11 = rowIndex10.getCell(1);
            cell11.setText("工作人员");
            XWPFTableCell cell12 = rowIndex10.getCell(2);
            cell12.setText("所属省份");
            XWPFTableCell cell13 = rowIndex10.getCell(3);
            cell13.setText("客户名称");
            XWPFTableCell cell15 = rowIndex10.getCell(4);
            cell15.setText("维修站类型");
            XWPFTableCell cell16 = rowIndex10.getCell(5);
            cell16.setText("具体品牌");
            XWPFTableCell cell17 = rowIndex10.getCell(6);
            cell17.setText("客户代码");
            XWPFTableCell cell18 = rowIndex10.getCell(7);
            cell18.setText("客户状态");
            XWPFTableCell cell19 = rowIndex10.getCell(8);
            cell19.setText("客户类型");
            XWPFTableCell cell20 = rowIndex10.getCell(9);
            cell20.setText("油漆品牌");
            XWPFTableCell cell21 = rowIndex10.getCell(10);
            cell21.setText("品牌定位");
            XWPFTableCell cell22 = rowIndex10.getCell(11);
            cell22.setText("服务商");
            XWPFTableCell cell23 = rowIndex10.getCell(12);
            cell23.setText("重点工作分类");
            XWPFTableCell cell24 = rowIndex10.getCell(13);
            cell24.setText("服务自我评估");
            ExportWordUtil.setTableWidth(table, "13000");

            int i = 1;
            for (VstarUserKpiReport_Plan plan : planList) {
                XWPFTableRow rowIndex = table.getRow(i);
                XWPFTableCell cell1 = rowIndex.getCell(0);
                cell1.setText(plan.getDateTime());
                XWPFTableCell cell2 = rowIndex.getCell(1);
                cell2.setText(plan.getWorkUser());
                XWPFTableCell cell3 = rowIndex.getCell(2);
                cell3.setText(plan.getProvice());
                XWPFTableCell cell4 = rowIndex.getCell(3);
                cell4.setText(plan.getCustomerUser());
                XWPFTableCell cell5 = rowIndex.getCell(4);
                cell5.setText(plan.getCategory());

                XWPFTableCell cell6 = rowIndex.getCell(5);
                cell6.setText(plan.getBrand());
                XWPFTableCell cell7 = rowIndex.getCell(6);
                cell7.setText(plan.getStationNum());
                XWPFTableCell cell8 = rowIndex.getCell(7);
                cell8.setText(plan.getCustomerStat());
                XWPFTableCell cell9 = rowIndex.getCell(8);
                cell9.setText(plan.getCustomerType());
                cell10 = rowIndex.getCell(9);
                cell10.setText(plan.getPaintBrand());
                cell11 = rowIndex.getCell(10);
                cell11.setText(plan.getProduct_position());
                cell12 = rowIndex.getCell(11);
                cell12.setText(plan.getServiceCompany());
                cell13 = rowIndex.getCell(12);
                cell13.setText(plan.getWorkType());
                XWPFTableCell cell14 = rowIndex.getCell(13);
                cell14.setText(plan.getServicePoint());
                i++;
            }
        }
        OutputStream output = new FileOutputStream(filePath);
        document.write(output);
        output.close();
    }


    public static void exportCustomerToWord(CustomerStatVo customerStatVo, String filePath) throws IOException {
        FileInputStream fileInputStream = new FileInputStream(filePath);
        CustomXWPFDocument document = new CustomXWPFDocument(fileInputStream);
        VstarCustomerSatisfactionReport data = customerStatVo.getData();
        //获取品牌列表
        List<String[]> brandArray = data.getVstarCustomerSatisfactionReport_brand().getBrandArray();
        //获取其他品牌列表
        List<String[]> otherBrandList = data.getVstarCustomerSatisfactionReport_brand().getOtherBrandList();
        //获取服务目标列表
        List<String[]> target = data.getVstarServiceReport_Target().getTarget();
        //获取其他服务目标列表
        List<String[]> otherTarget = data.getVstarServiceReport_Target().getOtherTarget();
        //获取表格数据
        List<String[]> score = customerStatVo.getSocre();
        //汽车品牌SVG
        String brandSvgList = customerStatVo.getResponseKpi().get(0);
        //服务目标SVG
        String targetSvgList = customerStatVo.getResponseKpi().get(1);
        //满意度SVG
        String customerSvgList = customerStatVo.getResponseKpi().get(2);

        //添加标题
        XWPFParagraph titleParagraphh1 = document.createParagraph();
        //设置段落居中
        titleParagraphh1.setAlignment(ParagraphAlignment.CENTER);
        XWPFRun titleParagraphRunh1 = titleParagraphh1.createRun();
        titleParagraphRunh1.setFontSize(17);
        titleParagraphRunh1.setText("所属汽车品牌");
        titleParagraphRunh1.setFontFamily("微软雅黑");
        if (null != brandArray && brandArray.size() > 0) {
            //创建表格
            Double countValue = customerStatVo.getData().getVstarCustomerSatisfactionReport_brand().getCountPerson().doubleValue();
            int row = brandArray.size() + 2;
            int column = 3;
            XWPFTable table = document.createTable(row, column);
            XWPFTableRow rowIndex10 = table.getRow(0);
            XWPFTableCell cell10 = rowIndex10.getCell(0);
            cell10.setText("品牌");
            XWPFTableCell cell11 = rowIndex10.getCell(1);
            cell11.setText("小计");
            XWPFTableCell cell12 = rowIndex10.getCell(2);
            cell12.setText("比例");
            ExportWordUtil.setTableWidth(table, "10000");

            int i = 1;
            for (String[] brandStr : brandArray) {
                //填充数据
                XWPFTableRow rowIndex = table.getRow(i);
                XWPFTableCell cell1 = rowIndex.getCell(0);
                cell1.setText(brandStr[0]);
                XWPFTableCell cell2 = rowIndex.getCell(1);
                cell2.setText(brandStr[1]);
                XWPFTableCell cell3 = rowIndex.getCell(2);
                cell3.setText(doubleGeTowDecimal(Double.valueOf(brandStr[1]) / countValue));
                i++;
            }
            XWPFTableRow rowIndex = table.getRow(brandArray.size() + 1);
            XWPFTableCell cell1 = rowIndex.getCell(0);
            cell1.setText("本题有效填写人次");
            XWPFTableCell cell2 = rowIndex.getCell(1);
            cell2.setText(data.getVstarCustomerSatisfactionReport_brand().getCountPerson() + "");
        }


        if (null != otherBrandList && otherBrandList.size() > 0) {
            //添加标题
            titleParagraphh1 = document.createParagraph();
            //设置段落居中
            titleParagraphh1.setAlignment(ParagraphAlignment.LEFT);
            titleParagraphRunh1 = titleParagraphh1.createRun();
            titleParagraphRunh1.setText("其他品牌");
            titleParagraphRunh1.setFontSize(10);
            titleParagraphRunh1.setFontFamily("微软雅黑");
            //创建表格
            int row = otherBrandList.size() + 1;
            int column = 2;
            XWPFTable table = document.createTable(row, column);
            XWPFTableRow rowIndex10 = table.getRow(0);
            XWPFTableCell cell10 = rowIndex10.getCell(0);
            cell10.setText("品牌");
            XWPFTableCell cell11 = rowIndex10.getCell(1);
            cell11.setText("小计");
            ExportWordUtil.setTableWidth(table, "10000");
            int i = 1;
            for (String[] otherBrandStr : otherBrandList) {
                //填充数据
                XWPFTableRow rowIndex = table.getRow(i);
                XWPFTableCell cell1 = rowIndex.getCell(0);
                cell1.setText(otherBrandStr[0]);
                XWPFTableCell cell2 = rowIndex.getCell(1);
                cell2.setText(otherBrandStr[1]);
                i++;
            }
        }

        //汽车品牌SVG
        if (StringUtils.isNotEmpty(brandSvgList)) {
            XWPFParagraph pargraph = document.createParagraph();
            XWPFRun run = pargraph.createRun();
            ByteArrayOutputStream baossvg = new ByteArrayOutputStream();
            WordUtil.convertToPng(brandSvgList, baossvg);

            try {
                ByteArrayInputStream swapStream = new ByteArrayInputStream(baossvg.toByteArray());
                run.addPicture(swapStream, CustomXWPFDocument.PICTURE_TYPE_PNG, "brandsvg.png", Units.toEMU(500), Units.toEMU(300));
            } catch (Exception e) {
                e.printStackTrace();
            }
            baossvg.close();
        }
        //添加标题
        titleParagraphh1 = document.createParagraph();
        //设置段落居中
        titleParagraphh1.setAlignment(ParagraphAlignment.CENTER);
        titleParagraphRunh1 = titleParagraphh1.createRun();
        titleParagraphRunh1.setFontSize(17);
        titleParagraphRunh1.setText("服务项目");
        titleParagraphRunh1.setFontFamily("微软雅黑");
        if (target != null && target.size() > 0) {
            int row = target.size() + 2;
            int column = 3;
            Double countValue = data.getVstarCustomerSatisfactionReport_brand().getCountPerson().doubleValue();
            XWPFTable table = document.createTable(row, column);
            XWPFTableRow rowIndex10 = table.getRow(0);
            XWPFTableCell cell10 = rowIndex10.getCell(0);
            cell10.setText("选项");
            XWPFTableCell cell11 = rowIndex10.getCell(1);
            cell11.setText("小计");
            XWPFTableCell cell12 = rowIndex10.getCell(2);
            cell12.setText("比例");
            ExportWordUtil.setTableWidth(table, "10000");
            int i = 1;
            for (String[] targetStr : target) {
                //填充数据
                XWPFTableRow rowIndex = table.getRow(i);
                XWPFTableCell cell1 = rowIndex.getCell(0);
                cell1.setText(targetStr[0]);
                XWPFTableCell cell2 = rowIndex.getCell(1);
                cell2.setText(targetStr[1]);
                XWPFTableCell cell3 = rowIndex.getCell(2);
                cell3.setText(doubleGeTowDecimal(Double.valueOf(targetStr[1]) / countValue));
                i++;
            }
            XWPFTableRow rowIndex = table.getRow(target.size() + 1);
            XWPFTableCell cell1 = rowIndex.getCell(0);
            cell1.setText("本题有效填写人次");
            XWPFTableCell cell2 = rowIndex.getCell(1);
            cell2.setText(data.getVstarCustomerSatisfactionReport_brand().getCountPerson() + "");
        }

        //添加标题
        titleParagraphh1 = document.createParagraph();
        //设置段落居中
        titleParagraphh1.setAlignment(ParagraphAlignment.LEFT);
        titleParagraphRunh1 = titleParagraphh1.createRun();
        titleParagraphRunh1.setFontSize(10);
        titleParagraphRunh1.setText("其他包括");
        titleParagraphRunh1.setFontFamily("微软雅黑");
        if (otherTarget != null && otherTarget.size() > 0) {
            int row = target.size() + 1;
            int column = 4;
            XWPFTable table = document.createTable(row, column);
            XWPFTableRow rowIndex10 = table.getRow(0);
            XWPFTableCell cell10 = rowIndex10.getCell(0);
            cell10.setText("序号");
            XWPFTableCell cell11 = rowIndex10.getCell(1);
            cell11.setText("提交报告时间");
            XWPFTableCell cell12 = rowIndex10.getCell(2);
            cell12.setText("服务项目");
            XWPFTableCell cell13 = rowIndex10.getCell(3);
            cell13.setText("技术人员");
            ExportWordUtil.setTableWidth(table, "10000");
            int i = 1;
            for (String[] targetStr : otherTarget) {
                //填充数据
                XWPFTableRow rowIndex = table.getRow(i);
                XWPFTableCell cell1 = rowIndex.getCell(0);
                cell1.setText(targetStr[0]);
                XWPFTableCell cell2 = rowIndex.getCell(1);
                cell2.setText(targetStr[1]);
                XWPFTableCell cell3 = rowIndex.getCell(2);
                cell3.setText(targetStr[2]);
                XWPFTableCell cell4 = rowIndex.getCell(3);
                cell4.setText(targetStr[3]);
                i++;
            }
        }

        //服务目标SVG
        if (StringUtils.isNotEmpty(targetSvgList)) {
            XWPFParagraph pargraph = document.createParagraph();
            XWPFRun run = pargraph.createRun();
            ByteArrayOutputStream baossvg = new ByteArrayOutputStream();
            WordUtil.convertToPng(targetSvgList, baossvg);

            try {
                ByteArrayInputStream swapStream = new ByteArrayInputStream(baossvg.toByteArray());
                run.addPicture(swapStream, CustomXWPFDocument.PICTURE_TYPE_PNG, "targetsvg.png", Units.toEMU(500), Units.toEMU(300));
            } catch (Exception e) {
                e.printStackTrace();
            }
            baossvg.close();
        }


        //添加标题
        titleParagraphh1 = document.createParagraph();
        //设置段落居中
        titleParagraphh1.setAlignment(ParagraphAlignment.CENTER);
        titleParagraphRunh1 = titleParagraphh1.createRun();
        titleParagraphRunh1.setFontSize(17);
        titleParagraphRunh1.setText("技术服务满意度");
        titleParagraphRunh1.setFontFamily("微软雅黑");

        titleParagraphh1 = document.createParagraph();
        //设置段落居中
        titleParagraphh1.setAlignment(ParagraphAlignment.LEFT);
        titleParagraphRunh1 = titleParagraphh1.createRun();
        titleParagraphRunh1.setFontSize(10);
        titleParagraphRunh1.setText("该矩阵题平均分");
        titleParagraphRunh1.setFontFamily("微软雅黑");
        if (score != null && score.size() > 0) {
            int row = score.size() + 1;
            int column = 7;
            XWPFTable table = document.createTable(row, column);
            XWPFTableRow rowIndex10 = table.getRow(0);
            XWPFTableCell cell10 = rowIndex10.getCell(0);
            cell10.setText("题目/选项");
            XWPFTableCell cell11 = rowIndex10.getCell(1);
            cell11.setText("100%");
            XWPFTableCell cell12 = rowIndex10.getCell(2);
            cell12.setText("80%");
            XWPFTableCell cell13 = rowIndex10.getCell(3);
            cell13.setText("60%");
            XWPFTableCell cell14 = rowIndex10.getCell(4);
            cell14.setText("40%");
            XWPFTableCell cell15 = rowIndex10.getCell(5);
            cell15.setText("20%");
            XWPFTableCell cell16 = rowIndex10.getCell(6);
            cell16.setText("平均分");
            ExportWordUtil.setTableWidth(table, "10000");

            int i = 1;
            for (String[] scoreStr : score) {
                //填充数据
                XWPFTableRow rowIndex = table.getRow(i);
                XWPFTableCell cell1 = rowIndex.getCell(0);
                cell1.setText(scoreStr[0]);
                XWPFTableCell cell2 = rowIndex.getCell(1);
                cell2.setText(scoreStr[1] + "(" + scoreStr[2] + ")");
                XWPFTableCell cell3 = rowIndex.getCell(2);
                cell3.setText(scoreStr[3] + "(" + scoreStr[4] + ")");
                XWPFTableCell cell4 = rowIndex.getCell(3);
                cell4.setText(scoreStr[5] + "(" + scoreStr[6] + ")");
                XWPFTableCell cell5 = rowIndex.getCell(4);
                cell5.setText(scoreStr[7] + "(" + scoreStr[8] + ")");
                XWPFTableCell cell6 = rowIndex.getCell(5);
                cell6.setText(scoreStr[9] + "(" + scoreStr[10] + ")");
                XWPFTableCell cell7 = rowIndex.getCell(6);
                cell7.setText(scoreStr[11]);
                i++;
            }
        }

        //满意度SVG
        if (StringUtils.isNotEmpty(customerSvgList)) {
            XWPFParagraph pargraph = document.createParagraph();
            XWPFRun run = pargraph.createRun();
            ByteArrayOutputStream baossvg = new ByteArrayOutputStream();
            WordUtil.convertToPng(customerSvgList, baossvg);

            try {
                ByteArrayInputStream swapStream = new ByteArrayInputStream(baossvg.toByteArray());
                run.addPicture(swapStream, CustomXWPFDocument.PICTURE_TYPE_PNG, "customersvg.png", Units.toEMU(500), Units.toEMU(300));
            } catch (Exception e) {
                e.printStackTrace();
            }
            baossvg.close();
        }
        OutputStream output = new FileOutputStream(filePath);
        document.write(output);
        output.close();
    }

    //保留2位小数 并转成String
    private static String doubleGeTowDecimal(Double doubleValue) {
        DecimalFormat format = new DecimalFormat("#0.00");
        String doubleStr = format.format(doubleValue * 100);
        return doubleStr + "%";
    }


    public static void exportServiceToWord(ServiceResponseVo serviceResponseVo, String filePath) throws IOException {
        FileInputStream fileInputStream = new FileInputStream(filePath);
        CustomXWPFDocument document = new CustomXWPFDocument(fileInputStream);
        //获取销售区域
        List<String[]> provinceList = serviceResponseVo.getServiceReport().getProvinceLsit();
        //获取客户状态
        List<String[]> customerStatList = serviceResponseVo.getServiceReport().getCustomerStatList();
        //获取客户类型
        List<String[]> customerTypeList = serviceResponseVo.getServiceReport().getCustomerTypeList();
        //获取维修站类型
        VstarServiceReport_ServiceType categort = serviceResponseVo.getServiceReport().getVstarServiceReport_serviceType();
        //获取品牌
        List<String[]> brandArray = serviceResponseVo.getServiceReport().getVstarServiceReport_brand().getBrandArray();
        //获取其他品牌
        List<String[]> otherBrandList = serviceResponseVo.getServiceReport().getVstarServiceReport_brand().getOtherBrandList();
        //获取油漆品牌
        List<String[]> paintBrandList = serviceResponseVo.getServiceReport().getPaintBrandList();
        //获取品牌定位
        List<String[]> productPositionList = serviceResponseVo.getServiceReport().getProductPositionList();
        //获取修站目前钣喷维修流程中面对最大问题
        List<String[]> maintainBigProblemList = serviceResponseVo.getServiceReport().getMaintainBigProblem();
        //获取该维修站的主要诉求
        List<String[]> stationAppealList = serviceResponseVo.getServiceReport().getStationAppeal();
        //获取服务目标
        List<String[]> target = serviceResponseVo.getServiceReport().getVstarServiceReport_target().getTarget();
        //获取其他服务目标
        List<String[]> otherTarget = serviceResponseVo.getServiceReport().getVstarServiceReport_target().getOtherTarget();
        //获取工作内容
        //获取没有完成-后续无法跟进
        Integer noComplete_UnableToFollowUp = serviceResponseVo.getServiceReport().getVstarServiceReport_results().getNoComplete_UnableToFollowUp();
        //获取没有完成-需后续跟进
        Integer noComplete_NeedToFollowUp = serviceResponseVo.getServiceReport().getVstarServiceReport_results().getNoComplete_NeedToFollowUp();
        //获取已完成-但需要其他部门跟进
        Integer complete_NeedOthersToFollowUp = serviceResponseVo.getServiceReport().getVstarServiceReport_results().getComplete_NeedOthersToFollowUp();
        //获取已完成
        Integer complete = serviceResponseVo.getServiceReport().getVstarServiceReport_results().getComplete();
        //获取有效填写人次
        Integer countPerson = serviceResponseVo.getServiceReport().getVstarServiceReport_results().getCountPerson();
        //获取已完成，但需要其他部门跟进
        List<VstarServiceReport_CompleteFollowUp> completeFollowUps = serviceResponseVo.getServiceReport().getVstarServiceReport_results().getCompleteFollowUps();
        //汽车品牌SVG
        String brandSvgList = serviceResponseVo.getKpiResponse().get(0);
        //服务目标SVG
        String targetSvgList = serviceResponseVo.getKpiResponse().get(1);
        //服务结果SVG
        String resultSvgList = serviceResponseVo.getKpiResponse().get(2);

        //添加标题
        XWPFParagraph titleParagraphh1 = document.createParagraph();
        //设置段落居中
        titleParagraphh1.setAlignment(ParagraphAlignment.CENTER);
        XWPFRun titleParagraphRunh1 = titleParagraphh1.createRun();
        titleParagraphRunh1.setFontSize(17);
        titleParagraphRunh1.setText("销售区域");
        titleParagraphRunh1.setFontFamily("微软雅黑");
        if (provinceList != null && provinceList.size() > 0) {
            int row = provinceList.size() + 2;
            int column = 3;
            XWPFTable table = document.createTable(row, column);
            XWPFTableRow rowIndex10 = table.getRow(0);
            XWPFTableCell cell10 = rowIndex10.getCell(0);
            cell10.setText("选项");
            XWPFTableCell cell11 = rowIndex10.getCell(1);
            cell11.setText("小计");
            XWPFTableCell cell12 = rowIndex10.getCell(2);
            cell12.setText("比例");
            ExportWordUtil.setTableWidth(table, "10000");
            Double countValue = 0D;
            for (String[] str : provinceList) {
                countValue += Double.valueOf(str[1]);
            }
            int i = 1;
            for (String[] str : provinceList) {
                XWPFTableRow rowIndex = table.getRow(i);
                XWPFTableCell cell1 = rowIndex.getCell(0);
                cell1.setText(str[0]);
                XWPFTableCell cell2 = rowIndex.getCell(1);
                cell2.setText(str[1]);
                XWPFTableCell cell3 = rowIndex.getCell(2);
                cell3.setText(doubleGeTowDecimal(Double.valueOf(str[1]) / countValue));
                i++;
            }
            XWPFTableRow rowIndex = table.getRow(provinceList.size() + 1);
            XWPFTableCell cell1 = rowIndex.getCell(0);
            cell1.setText("有效填写报告数量");
            XWPFTableCell cell2 = rowIndex.getCell(1);
            cell2.setText(serviceResponseVo.getServiceReport().getVstarServiceReport_brand().getCountPerson() + "");

        }

        //添加标题
        titleParagraphh1 = document.createParagraph();
        //设置段落居中
        titleParagraphh1.setAlignment(ParagraphAlignment.CENTER);
        titleParagraphRunh1 = titleParagraphh1.createRun();
        titleParagraphRunh1.setFontSize(17);
        titleParagraphRunh1.setText("客户状态");
        titleParagraphRunh1.setFontFamily("微软雅黑");
        if (customerStatList != null && customerStatList.size() > 0) {
            int row = customerStatList.size() + 2;
            int column = 3;
            XWPFTable table = document.createTable(row, column);
            XWPFTableRow rowIndex10 = table.getRow(0);
            XWPFTableCell cell10 = rowIndex10.getCell(0);
            cell10.setText("选项");
            XWPFTableCell cell11 = rowIndex10.getCell(1);
            cell11.setText("小计");
            XWPFTableCell cell12 = rowIndex10.getCell(2);
            cell12.setText("比例");
            ExportWordUtil.setTableWidth(table, "10000");

            Double countValue = 0D;
            for (String[] str : customerStatList) {
                countValue += Double.valueOf(str[1]);
            }
            int i = 1;
            for (String[] str : customerStatList) {
                XWPFTableRow rowIndex = table.getRow(i);
                XWPFTableCell cell1 = rowIndex.getCell(0);
                cell1.setText(str[0]);
                XWPFTableCell cell2 = rowIndex.getCell(1);
                cell2.setText(str[1]);
                XWPFTableCell cell3 = rowIndex.getCell(2);
                cell3.setText(doubleGeTowDecimal(Double.valueOf(str[1]) / countValue));
                i++;
            }
            XWPFTableRow rowIndex = table.getRow(customerStatList.size() + 1);
            XWPFTableCell cell1 = rowIndex.getCell(0);
            cell1.setText("有效填写报告数量");
            XWPFTableCell cell2 = rowIndex.getCell(1);
            cell2.setText(serviceResponseVo.getServiceReport().getVstarServiceReport_brand().getCountPerson() + "");
        }

        //添加标题
        titleParagraphh1 = document.createParagraph();
        //设置段落居中
        titleParagraphh1.setAlignment(ParagraphAlignment.CENTER);
        titleParagraphRunh1 = titleParagraphh1.createRun();
        titleParagraphRunh1.setFontSize(17);
        titleParagraphRunh1.setText("客户类型");
        titleParagraphRunh1.setFontFamily("微软雅黑");
        if (customerTypeList != null && customerTypeList.size() > 0) {
            int row = customerTypeList.size() + 2;
            int column = 3;
            XWPFTable table = document.createTable(row, column);
            XWPFTableRow rowIndex10 = table.getRow(0);
            XWPFTableCell cell10 = rowIndex10.getCell(0);
            cell10.setText("选项");
            XWPFTableCell cell11 = rowIndex10.getCell(1);
            cell11.setText("小计");
            XWPFTableCell cell12 = rowIndex10.getCell(2);
            cell12.setText("比例");
            ExportWordUtil.setTableWidth(table, "10000");
            Double countValue = 0D;
            for (String[] str : customerTypeList) {
                countValue += Double.valueOf(str[1]);
            }
            int i = 1;
            for (String[] str : customerTypeList) {
                XWPFTableRow rowIndex = table.getRow(i);
                XWPFTableCell cell1 = rowIndex.getCell(0);
                cell1.setText(str[0]);
                XWPFTableCell cell2 = rowIndex.getCell(1);
                cell2.setText(str[1]);
                i++;
            }
            XWPFTableRow rowIndex = table.getRow(customerTypeList.size() + 1);
            XWPFTableCell cell1 = rowIndex.getCell(0);
            cell1.setText("有效填写报告数量");
            XWPFTableCell cell2 = rowIndex.getCell(1);
            cell2.setText(serviceResponseVo.getServiceReport().getVstarServiceReport_brand().getCountPerson() + "");
        }


        //添加标题
        titleParagraphh1 = document.createParagraph();
        //设置段落居中
        titleParagraphh1.setAlignment(ParagraphAlignment.CENTER);
        titleParagraphRunh1 = titleParagraphh1.createRun();
        titleParagraphRunh1.setFontSize(17);
        titleParagraphRunh1.setText("维修站类型");
        titleParagraphRunh1.setFontFamily("微软雅黑");
        if (null != categort) {
            //创建表格
            Double countDouble = Double.valueOf(categort.getCountPerson().toString());
            int row = 6;
            int column = 3;
            XWPFTable table = document.createTable(row, column);
            XWPFTableRow rowIndex10 = table.getRow(0);
            XWPFTableCell cell10 = rowIndex10.getCell(0);
            cell10.setText("选项");
            XWPFTableCell cell11 = rowIndex10.getCell(1);
            cell11.setText("小计");
            XWPFTableCell cell12 = rowIndex10.getCell(2);
            cell12.setText("比例");
            ExportWordUtil.setTableWidth(table, "10000");

            XWPFTableRow rowIndex1 = table.getRow(1);
            XWPFTableCell cell = rowIndex1.getCell(0);
            cell.setText("4S店");
            cell = rowIndex1.getCell(1);
            cell.setText(categort.getFourS() + "");
            cell = rowIndex1.getCell(2);
            cell.setText(doubleGeTowDecimal(categort.getFourS() / countDouble));
            XWPFTableRow rowIndex2 = table.getRow(2);
            cell = rowIndex2.getCell(0);
            cell.setText("钣喷中心（BPC）");
            cell = rowIndex2.getCell(1);
            cell.setText(categort.getBPC() + "");
            cell = rowIndex2.getCell(2);
            cell.setText(doubleGeTowDecimal(categort.getBPC() / countDouble));
            XWPFTableRow rowIndex3 = table.getRow(3);
            cell = rowIndex3.getCell(0);
            cell.setText("连锁维修站（FBS）");
            cell = rowIndex3.getCell(1);
            cell.setText(categort.getFBS() + "");
            cell = rowIndex3.getCell(2);
            cell.setText(doubleGeTowDecimal(categort.getFBS() / countDouble));
            XWPFTableRow rowIndex4 = table.getRow(4);
            cell = rowIndex4.getCell(0);
            cell.setText("独立维修站(IBS)");
            cell = rowIndex4.getCell(1);
            cell.setText(categort.getIBS() + "");
            cell = rowIndex4.getCell(2);
            cell.setText(doubleGeTowDecimal(categort.getIBS() / countDouble));
            XWPFTableRow rowIndex5 = table.getRow(5);
            cell = rowIndex5.getCell(0);
            cell.setText("本题有效填写人次");
            cell = rowIndex5.getCell(1);
            cell.setText(categort.getCountPerson() + "");
            cell = rowIndex5.getCell(2);
            cell.setText("");
        }
        //添加标题
        titleParagraphh1 = document.createParagraph();
        //设置段落居中
        titleParagraphh1.setAlignment(ParagraphAlignment.CENTER);
        titleParagraphRunh1 = titleParagraphh1.createRun();
        titleParagraphRunh1.setFontSize(17);
        titleParagraphRunh1.setText("具体品牌");
        titleParagraphRunh1.setFontFamily("微软雅黑");
        if (null != brandArray && brandArray.size() > 0) {
            //创建表格
            Double countValue = Double.valueOf(serviceResponseVo.getServiceReport().getVstarServiceReport_brand().getCountPerson().toString());
            int row = brandArray.size() + 2;
            int column = 3;
            XWPFTable table = document.createTable(row, column);
            XWPFTableRow rowIndex10 = table.getRow(0);
            XWPFTableCell cell10 = rowIndex10.getCell(0);
            cell10.setText("品牌");
            XWPFTableCell cell11 = rowIndex10.getCell(1);
            cell11.setText("小计");
            XWPFTableCell cell12 = rowIndex10.getCell(2);
            cell12.setText("比例");
            ExportWordUtil.setTableWidth(table, "10000");

            int i = 1;
            for (String[] brandStr : brandArray) {
                //填充数据
                XWPFTableRow rowIndex = table.getRow(i);
                XWPFTableCell cell1 = rowIndex.getCell(0);
                cell1.setText(brandStr[0]);
                XWPFTableCell cell2 = rowIndex.getCell(1);
                cell2.setText(brandStr[1]);
                XWPFTableCell cell3 = rowIndex.getCell(2);
                cell3.setText(doubleGeTowDecimal(Double.valueOf(brandStr[1]) / countValue));
                i++;
            }
            XWPFTableRow rowIndex = table.getRow(brandArray.size() + 1);
            XWPFTableCell cell1 = rowIndex.getCell(0);
            cell1.setText("本题有效填写人次");
            XWPFTableCell cell2 = rowIndex.getCell(1);
            cell2.setText(serviceResponseVo.getServiceReport().getVstarServiceReport_brand().getCountPerson() + "");
        }

        //汽车品牌SVG
        if (StringUtils.isNotEmpty(brandSvgList)) {
            XWPFParagraph pargraph = document.createParagraph();
            XWPFRun run = pargraph.createRun();
            ByteArrayOutputStream baossvg = new ByteArrayOutputStream();
            WordUtil.convertToPng(brandSvgList, baossvg);

            try {
                ByteArrayInputStream swapStream = new ByteArrayInputStream(baossvg.toByteArray());
                run.addPicture(swapStream, CustomXWPFDocument.PICTURE_TYPE_PNG, "brandsvg.png", Units.toEMU(500), Units.toEMU(300));
            } catch (Exception e) {
                e.printStackTrace();
            }
            baossvg.close();
        }

        if (null != otherBrandList && otherBrandList.size() > 0) {
            //添加标题
            titleParagraphh1 = document.createParagraph();
            //设置段落居中
            titleParagraphh1.setAlignment(ParagraphAlignment.LEFT);
            titleParagraphRunh1 = titleParagraphh1.createRun();
            titleParagraphRunh1.setText("其他品牌");
            titleParagraphRunh1.setFontSize(10);
            titleParagraphRunh1.setFontFamily("微软雅黑");
            //创建表格
            int row = otherBrandList.size() + 1;
            int column = 2;
            XWPFTable table = document.createTable(row, column);
            XWPFTableRow rowIndex10 = table.getRow(0);
            XWPFTableCell cell10 = rowIndex10.getCell(0);
            cell10.setText("品牌");
            XWPFTableCell cell11 = rowIndex10.getCell(1);
            cell11.setText("小计");
            ExportWordUtil.setTableWidth(table, "10000");
            int i = 1;
            for (String[] otherBrandStr : otherBrandList) {
                //填充数据
                XWPFTableRow rowIndex = table.getRow(i);
                XWPFTableCell cell1 = rowIndex.getCell(0);
                cell1.setText(otherBrandStr[0]);
                XWPFTableCell cell2 = rowIndex.getCell(1);
                cell2.setText(otherBrandStr[1]);
                i++;
            }
        }

        //添加标题
        titleParagraphh1 = document.createParagraph();
        //设置段落居中
        titleParagraphh1.setAlignment(ParagraphAlignment.CENTER);
        titleParagraphRunh1 = titleParagraphh1.createRun();
        titleParagraphRunh1.setFontSize(17);
        titleParagraphRunh1.setText("油漆品牌");
        titleParagraphRunh1.setFontFamily("微软雅黑");
        if (paintBrandList != null && paintBrandList.size() > 0) {
            int row = paintBrandList.size() + 2;
            int column = 3;
            XWPFTable table = document.createTable(row, column);
            XWPFTableRow rowIndex10 = table.getRow(0);
            XWPFTableCell cell10 = rowIndex10.getCell(0);
            cell10.setText("选项");
            XWPFTableCell cell11 = rowIndex10.getCell(1);
            cell11.setText("小计");
            XWPFTableCell cell12 = rowIndex10.getCell(2);
            cell12.setText("比例");
            ExportWordUtil.setTableWidth(table, "10000");
            Double countValue = 0D;
            for (String[] str : paintBrandList) {
                countValue += Double.valueOf(str[1]);
            }
            int i = 1;
            for (String[] str : paintBrandList) {
                XWPFTableRow rowIndex = table.getRow(i);
                XWPFTableCell cell1 = rowIndex.getCell(0);
                cell1.setText(str[0]);
                XWPFTableCell cell2 = rowIndex.getCell(1);
                cell2.setText(str[1]);
                XWPFTableCell cell3 = rowIndex.getCell(2);
                cell3.setText(doubleGeTowDecimal(Double.valueOf(str[1]) / countValue));
                i++;
            }
            XWPFTableRow rowIndex = table.getRow(paintBrandList.size() + 1);
            XWPFTableCell cell3 = rowIndex.getCell(0);
            cell3.setText("本题有效填写人次");
            XWPFTableCell cell2 = rowIndex.getCell(1);
            cell2.setText(serviceResponseVo.getServiceReport().getVstarServiceReport_brand().getCountPerson() + "");
        }

        //添加标题
        titleParagraphh1 = document.createParagraph();
        //设置段落居中
        titleParagraphh1.setAlignment(ParagraphAlignment.CENTER);
        titleParagraphRunh1 = titleParagraphh1.createRun();
        titleParagraphRunh1.setFontSize(17);
        titleParagraphRunh1.setText("品牌定位");
        titleParagraphRunh1.setFontFamily("微软雅黑");
        if (productPositionList != null && productPositionList.size() > 0) {
            int row = productPositionList.size() + 2;
            int column = 3;
            XWPFTable table = document.createTable(row, column);
            XWPFTableRow rowIndex10 = table.getRow(0);
            XWPFTableCell cell10 = rowIndex10.getCell(0);
            cell10.setText("选项");
            XWPFTableCell cell11 = rowIndex10.getCell(1);
            cell11.setText("小计");
            XWPFTableCell cell12 = rowIndex10.getCell(2);
            cell12.setText("比例");
            ExportWordUtil.setTableWidth(table, "10000");

            Double countValue = 0D;
            for (String[] str : productPositionList) {
                countValue += Double.valueOf(str[1]);
            }
            int i = 1;
            for (String[] str : productPositionList) {
                XWPFTableRow rowIndex = table.getRow(i);
                XWPFTableCell cell1 = rowIndex.getCell(0);
                cell1.setText(str[0]);
                XWPFTableCell cell2 = rowIndex.getCell(1);
                cell2.setText(str[1]);
                XWPFTableCell cell3 = rowIndex.getCell(2);
                cell3.setText(doubleGeTowDecimal(Double.valueOf(str[1]) / countValue));
                i++;
            }
            XWPFTableRow rowIndex = table.getRow(productPositionList.size() + 1);
            XWPFTableCell cell3 = rowIndex.getCell(0);
            cell3.setText("本题有效填写人次");
            XWPFTableCell cell2 = rowIndex.getCell(1);
            cell2.setText(serviceResponseVo.getServiceReport().getVstarServiceReport_brand().getCountPerson() + "");
        }


        if (maintainBigProblemList != null && maintainBigProblemList.size() > 0) {
            //添加标题
            titleParagraphh1 = document.createParagraph();
            //设置段落居中
            titleParagraphh1.setAlignment(ParagraphAlignment.CENTER);
            titleParagraphRunh1 = titleParagraphh1.createRun();
            titleParagraphRunh1.setFontSize(17);
            titleParagraphRunh1.setText("修站目前钣喷维修流程中面对最大问题");
            titleParagraphRunh1.setFontFamily("微软雅黑");
            int row = maintainBigProblemList.size() + 2;
            int column = 3;
            XWPFTable table = document.createTable(row, column);
            XWPFTableRow rowIndex10 = table.getRow(0);
            XWPFTableCell cell10 = rowIndex10.getCell(0);
            cell10.setText("选项");
            XWPFTableCell cell11 = rowIndex10.getCell(1);
            cell11.setText("小计");
            XWPFTableCell cell12 = rowIndex10.getCell(2);
            cell12.setText("比例");
            ExportWordUtil.setTableWidth(table, "10000");

            Double countValue = 0D;
            for (String[] str : maintainBigProblemList) {
                countValue += Double.valueOf(str[1]);
            }
            int i = 1;
            for (String[] str : maintainBigProblemList) {
                XWPFTableRow rowIndex = table.getRow(i);
                XWPFTableCell cell1 = rowIndex.getCell(0);
                cell1.setText(str[0]);
                XWPFTableCell cell2 = rowIndex.getCell(1);
                cell2.setText(str[1]);
                XWPFTableCell cell3 = rowIndex.getCell(2);
                cell3.setText(doubleGeTowDecimal(Double.valueOf(str[1]) / countValue));
                i++;
            }
            XWPFTableRow rowIndex = table.getRow(maintainBigProblemList.size() + 1);
            XWPFTableCell cell3 = rowIndex.getCell(0);
            cell3.setText("本题有效填写人次");
            XWPFTableCell cell2 = rowIndex.getCell(1);
            cell2.setText(serviceResponseVo.getServiceReport().getVstarServiceReport_brand().getCountPerson() + "");
        }


        if (stationAppealList != null && stationAppealList.size() > 0) {
            //添加标题
            titleParagraphh1 = document.createParagraph();
            //设置段落居中
            titleParagraphh1.setAlignment(ParagraphAlignment.CENTER);
            titleParagraphRunh1 = titleParagraphh1.createRun();
            titleParagraphRunh1.setFontSize(17);
            titleParagraphRunh1.setText("该维修站的主要诉求 ");
            titleParagraphRunh1.setFontFamily("微软雅黑");
            int row = stationAppealList.size() + 2;
            int column = 3;
            XWPFTable table = document.createTable(row, column);
            XWPFTableRow rowIndex10 = table.getRow(0);
            XWPFTableCell cell10 = rowIndex10.getCell(0);
            cell10.setText("选项");
            XWPFTableCell cell11 = rowIndex10.getCell(1);
            cell11.setText("小计");
            XWPFTableCell cell12 = rowIndex10.getCell(2);
            cell12.setText("比例");
            ExportWordUtil.setTableWidth(table, "10000");

            Double countValue = 0D;
            for (String[] str : stationAppealList) {
                countValue += Double.valueOf(str[1]);
            }
            int i = 1;
            for (String[] str : stationAppealList) {
                XWPFTableRow rowIndex = table.getRow(i);
                XWPFTableCell cell1 = rowIndex.getCell(0);
                cell1.setText(str[0]);
                XWPFTableCell cell2 = rowIndex.getCell(1);
                cell2.setText(str[1]);
                XWPFTableCell cell3 = rowIndex.getCell(2);
                cell3.setText(doubleGeTowDecimal(Double.valueOf(str[1]) / countValue));
                i++;
            }
            XWPFTableRow rowIndex = table.getRow(stationAppealList.size() + 1);
            XWPFTableCell cell3 = rowIndex.getCell(0);
            cell3.setText("本题有效填写人次");
            XWPFTableCell cell2 = rowIndex.getCell(1);
            cell2.setText(serviceResponseVo.getServiceReport().getVstarServiceReport_brand().getCountPerson() + "");
        }


        //添加标题
        titleParagraphh1 = document.createParagraph();
        //设置段落居中
        titleParagraphh1.setAlignment(ParagraphAlignment.CENTER);
        titleParagraphRunh1 = titleParagraphh1.createRun();
        titleParagraphRunh1.setFontSize(17);
        titleParagraphRunh1.setText("服务项目");
        titleParagraphRunh1.setFontFamily("微软雅黑");
        if (target != null && target.size() > 0) {
            Double countValue = Double.valueOf(serviceResponseVo.getServiceReport().getVstarServiceReport_target().getCountPerson().toString());
            int row = target.size() + 2;
            int column = 3;
            XWPFTable table = document.createTable(row, column);
            XWPFTableRow rowIndex10 = table.getRow(0);
            XWPFTableCell cell10 = rowIndex10.getCell(0);
            cell10.setText("选项");
            XWPFTableCell cell11 = rowIndex10.getCell(1);
            cell11.setText("小计");
            XWPFTableCell cell12 = rowIndex10.getCell(2);
            cell12.setText("比例");
            ExportWordUtil.setTableWidth(table, "10000");
            int i = 1;
            for (String[] targetStr : target) {
                //填充数据
                XWPFTableRow rowIndex = table.getRow(i);
                XWPFTableCell cell1 = rowIndex.getCell(0);
                cell1.setText(targetStr[0]);
                XWPFTableCell cell2 = rowIndex.getCell(1);
                cell2.setText(targetStr[1]);
                XWPFTableCell cell3 = rowIndex.getCell(2);
                cell3.setText(doubleGeTowDecimal(Double.valueOf(targetStr[1]) / countValue));
                i++;
            }
            XWPFTableRow rowIndex = table.getRow(target.size() + 1);
            XWPFTableCell cell1 = rowIndex.getCell(0);
            cell1.setText("本题有效填写人次");
            XWPFTableCell cell2 = rowIndex.getCell(1);
            cell2.setText(serviceResponseVo.getServiceReport().getVstarServiceReport_target().getCountPerson() + "");
        }

        //服务目标品牌SVG
        if (StringUtils.isNotEmpty(targetSvgList)) {
            XWPFParagraph pargraph = document.createParagraph();
            XWPFRun run = pargraph.createRun();
            ByteArrayOutputStream baossvg = new ByteArrayOutputStream();
            WordUtil.convertToPng(targetSvgList, baossvg);

            try {
                ByteArrayInputStream swapStream = new ByteArrayInputStream(baossvg.toByteArray());
                run.addPicture(swapStream, CustomXWPFDocument.PICTURE_TYPE_PNG, "targetsvg.png", Units.toEMU(500), Units.toEMU(300));
            } catch (Exception e) {
                e.printStackTrace();
            }
            baossvg.close();
        }

        //添加标题
        titleParagraphh1 = document.createParagraph();
        //设置段落居中
        titleParagraphh1.setAlignment(ParagraphAlignment.LEFT);
        titleParagraphRunh1 = titleParagraphh1.createRun();
        titleParagraphRunh1.setFontSize(10);
        titleParagraphRunh1.setText("其他包括");
        titleParagraphRunh1.setFontFamily("微软雅黑");
        if (otherTarget != null && otherTarget.size() > 0) {
            int row = otherTarget.size() + 1;
            int column = 4;
            XWPFTable table = document.createTable(row, column);
            XWPFTableRow rowIndex10 = table.getRow(0);
            XWPFTableCell cell10 = rowIndex10.getCell(0);
            cell10.setText("序号");
            XWPFTableCell cell11 = rowIndex10.getCell(1);
            cell11.setText("提交报告时间");
            XWPFTableCell cell12 = rowIndex10.getCell(2);
            cell12.setText("服务项目");
            XWPFTableCell cell13 = rowIndex10.getCell(3);
            cell13.setText("技术人员");
            ExportWordUtil.setTableWidth(table, "10000");
            int i = 1;
            for (String[] targetStr : otherTarget) {
                //填充数据
                XWPFTableRow rowIndex = table.getRow(i);
                XWPFTableCell cell1 = rowIndex.getCell(0);
                cell1.setText(targetStr[0]);
                XWPFTableCell cell2 = rowIndex.getCell(1);
                cell2.setText(targetStr[1]);
                XWPFTableCell cell3 = rowIndex.getCell(2);
                cell3.setText(targetStr[2]);
                XWPFTableCell cell4 = rowIndex.getCell(3);
                cell4.setText(targetStr[3]);
                i++;
            }
        }

        //添加标题
        titleParagraphh1 = document.createParagraph();
        //设置段落居中
        titleParagraphh1.setAlignment(ParagraphAlignment.CENTER);
        titleParagraphRunh1 = titleParagraphh1.createRun();
        titleParagraphRunh1.setFontSize(10);
        titleParagraphRunh1.setText("技术服务具体工作内容以及结果");
        titleParagraphRunh1.setFontFamily("微软雅黑");
        //创建表格
        Double countValue = serviceResponseVo.getServiceReport().getVstarServiceReport_results().getCountPerson().doubleValue();
        int row = 6;
        int column = 3;
        XWPFTable table = document.createTable(row, column);
        XWPFTableRow rowIndex10 = table.getRow(0);
        XWPFTableCell cell10 = rowIndex10.getCell(0);
        cell10.setText("选项");
        XWPFTableCell cell11 = rowIndex10.getCell(1);
        cell11.setText("小计");
        XWPFTableCell cell12 = rowIndex10.getCell(2);
        cell12.setText("比例");
        ExportWordUtil.setTableWidth(table, "10000");

        XWPFTableRow rowIndex1 = table.getRow(1);
        XWPFTableCell cell = rowIndex1.getCell(0);
        cell.setText("没有完成，无法后续跟进");
        cell = rowIndex1.getCell(1);
        cell.setText(noComplete_UnableToFollowUp + "");
        cell = rowIndex1.getCell(2);
        cell.setText(doubleGeTowDecimal(Double.valueOf(noComplete_UnableToFollowUp) / countValue));
        XWPFTableRow rowIndex2 = table.getRow(2);
        cell = rowIndex2.getCell(0);
        cell.setText("没有完成，需后续跟进");
        cell = rowIndex2.getCell(1);
        cell.setText(noComplete_NeedToFollowUp + "");
        cell = rowIndex2.getCell(2);
        cell.setText(doubleGeTowDecimal(Double.valueOf(noComplete_NeedToFollowUp) / countValue));
        XWPFTableRow rowIndex3 = table.getRow(3);
        cell = rowIndex3.getCell(0);
        cell.setText("已完成，但需其他部门跟进");
        cell = rowIndex3.getCell(1);
        cell.setText(complete_NeedOthersToFollowUp + "");
        cell = rowIndex3.getCell(2);
        cell.setText(doubleGeTowDecimal(Double.valueOf(complete_NeedOthersToFollowUp) / countValue));
        XWPFTableRow rowIndex4 = table.getRow(4);
        cell = rowIndex4.getCell(0);
        cell.setText("已完成");
        cell = rowIndex4.getCell(1);
        cell.setText(complete + "");
        cell = rowIndex4.getCell(2);
        cell.setText(doubleGeTowDecimal(Double.valueOf(complete) / countValue));
        XWPFTableRow rowIndex5 = table.getRow(5);
        cell = rowIndex5.getCell(0);
        cell.setText("本题有效填写人次");
        cell = rowIndex5.getCell(1);
        cell.setText(serviceResponseVo.getServiceReport().getVstarServiceReport_results().getCountPerson() + "");
        cell = rowIndex5.getCell(2);
        cell.setText("");

        //服务目标品牌SVG
        if (StringUtils.isNotEmpty(resultSvgList)) {
            XWPFParagraph pargraph = document.createParagraph();
            XWPFRun run = pargraph.createRun();
            ByteArrayOutputStream baossvg = new ByteArrayOutputStream();
            WordUtil.convertToPng(resultSvgList, baossvg);
            try {
                ByteArrayInputStream swapStream = new ByteArrayInputStream(baossvg.toByteArray());
                run.addPicture(swapStream, CustomXWPFDocument.PICTURE_TYPE_PNG, "resultsvg.png", Units.toEMU(500), Units.toEMU(300));
            } catch (Exception e) {
                e.printStackTrace();
            }
            baossvg.close();
        }

        if (completeFollowUps != null && completeFollowUps.size() > 0) {
            //添加标题
            titleParagraphh1 = document.createParagraph();
            //设置段落居中
            titleParagraphh1.setAlignment(ParagraphAlignment.LEFT);
            titleParagraphRunh1 = titleParagraphh1.createRun();
            titleParagraphRunh1.setFontSize(10);
            titleParagraphRunh1.setText("已完成，但需其他部门跟进");
            titleParagraphRunh1.setFontFamily("微软雅黑");

            //创建表格
            row = completeFollowUps.size() + 1;
            column = 4;
            table = document.createTable(row, column);
            rowIndex10 = table.getRow(0);
            cell10 = rowIndex10.getCell(0);
            cell10.setText("序号");
            cell11 = rowIndex10.getCell(1);
            cell11.setText("提交报告时间");
            cell12 = rowIndex10.getCell(2);
            cell12.setText("跟进部门");
            XWPFTableCell cell13 = rowIndex10.getCell(3);
            cell13.setText("技术人员");
            ExportWordUtil.setTableWidth(table, "10000");

            int i = 1;
            for (VstarServiceReport_CompleteFollowUp completeFollowUp : completeFollowUps) {
                //填充数据
                XWPFTableRow rowIndex = table.getRow(i);
                XWPFTableCell cell1 = rowIndex.getCell(0);
                cell1.setText(completeFollowUp.getId() + "");
                XWPFTableCell cell2 = rowIndex.getCell(1);
                cell2.setText(completeFollowUp.getCreateTime());
                XWPFTableCell cell3 = rowIndex.getCell(2);
                cell3.setText(completeFollowUp.getAnswer());
                XWPFTableCell cell4 = rowIndex.getCell(3);
                cell4.setText(completeFollowUp.getUserName());
                i++;
            }
        }
        OutputStream output = new FileOutputStream(filePath);
        document.write(output);
        output.close();
    }

    public static void exportStationToWord(List<StationResponse> stationResponses, String filePath) throws IOException {
        FileInputStream fileInputStream = new FileInputStream(filePath);
        CustomXWPFDocument document = new CustomXWPFDocument(fileInputStream);

        if (stationResponses != null && stationResponses.size() > 0) {
            int row = stationResponses.size() + 1;
            int column = 5;
            XWPFTable table = document.createTable(row, column);
            XWPFTableRow rowIndex10 = table.getRow(0);
            XWPFTableCell cell10 = rowIndex10.getCell(0);
            cell10.setText("站点编号");
            XWPFTableCell cell11 = rowIndex10.getCell(1);
            cell11.setText("站点名称");
            XWPFTableCell cell12 = rowIndex10.getCell(2);
            cell12.setText("经销商名称");
//            XWPFTableCell cell13 = rowIndex10.getCell(3);
//            cell13.setText("省份");
            XWPFTableCell cell14 = rowIndex10.getCell(3);
            cell14.setText("城市");
            XWPFTableCell cell15 = rowIndex10.getCell(4);
            cell15.setText("创建人");
            ExportWordUtil.setTableWidth(table, "10000");

            int i = 1;
            for (StationResponse response : stationResponses) {
                XWPFTableRow rowIndex = table.getRow(i);
                XWPFTableCell cell1 = rowIndex.getCell(0);
                cell1.setText(response.getStationNum());
                XWPFTableCell cell2 = rowIndex.getCell(1);
                cell2.setText(response.getName());
                XWPFTableCell cell3 = rowIndex.getCell(2);
                cell3.setText(response.getDealersName());
//                XWPFTableCell cell4 = rowIndex.getCell(3);
//                cell4.setText(response.getProvince());
                XWPFTableCell cell5 = rowIndex.getCell(3);
                cell5.setText(response.getCity());
                XWPFTableCell cell6 = rowIndex.getCell(4);
                cell6.setText(response.getUserName());
                i++;
            }
        }
        OutputStream output = new FileOutputStream(filePath);
        document.write(output);
        output.close();
    }

    /***
     * 导出word 设置行宽
     * @param table
     * @param width
     */
    public static void setTableWidth(XWPFTable table, String width) {
        CTTbl ttbl = table.getCTTbl();
        CTTblPr tblPr = ttbl.getTblPr() == null ? ttbl.addNewTblPr() : ttbl.getTblPr();
        CTTblWidth tblWidth = tblPr.isSetTblW() ? tblPr.getTblW() : tblPr.addNewTblW();
        CTJc cTJc = tblPr.addNewJc();
        cTJc.setVal(STJc.Enum.forString("center"));
        tblWidth.setW(new BigInteger(width));
        tblWidth.setType(STTblWidth.DXA);
    }

    public static void setCellText(XWPFTableCell cell, int width,
                                   boolean isShd, int shdValue, String shdColor) {
        CTTc cttc = cell.getCTTc();
        CTTcPr ctPr = cttc.isSetTcPr() ? cttc.getTcPr() : cttc.addNewTcPr();
        CTShd ctshd = ctPr.isSetShd() ? ctPr.getShd() : ctPr.addNewShd();
        ctPr.addNewTcW().setW(BigInteger.valueOf(width));
        if (isShd) {
            if (shdValue > 0 && shdValue <= 38) {
                ctshd.setVal(STShd.Enum.forInt(shdValue));
            }
            if (shdColor != null) {
                // ctshd.setFill(shdColor);
                // ctshd.setColor("auto");
                ctshd.setColor(shdColor);
            }
        }

        ctPr.addNewVAlign().setVal(STVerticalJc.CENTER);
//        cttc.getPList().get(0).addNewPPr().addNewJc().setVal(STJc.CENTER);
//        cell.setText(text);
    }


    // word跨行并单元格
    public static void mergeCellsVertically(XWPFTable table, int col, int fromRow, int toRow) {
        for (int rowIndex = fromRow; rowIndex <= toRow; rowIndex++) {
            XWPFTableCell cell = table.getRow(rowIndex).getCell(col);
            if (rowIndex == fromRow) {
                // The first merged cell is set with RESTART merge value
                cell.getCTTc().addNewTcPr().addNewVMerge().setVal(STMerge.RESTART);
            } else {
                // Cells which join (merge) the first one, are set with CONTINUE
                cell.getCTTc().addNewTcPr().addNewVMerge().setVal(STMerge.CONTINUE);
            }

        }
    }

    public static void mergeCellsHorizontal(XWPFTable table, int row, int fromCell, int toCell) {
        for (int cellIndex = fromCell; cellIndex <= toCell; cellIndex++) {
            XWPFTableCell cell = table.getRow(row).getCell(cellIndex);
            if (cellIndex == fromCell) {
                // The first merged cell is set with RESTART merge value
                cell.getCTTc().addNewTcPr().addNewHMerge().setVal(STMerge.RESTART);
            } else {
                // Cells which join (merge) the first one, are set with CONTINUE
                cell.getCTTc().addNewTcPr().addNewHMerge().setVal(STMerge.CONTINUE);
            }
        }
    }


    public static void setCellStyle(XWPFTableCell cell, String text, boolean bold, String color, int fontSize) {
        XWPFParagraph p = cell.getParagraphs().get(0);
        XWPFRun r = p.createRun();
        if(StringUtils.isEmpty(text)) {
            r.setText(" ");
        } else {
            r.setText(text);
        }
        r.setColor(color);
        r.setBold(bold);
        r.setFontFamily("微软雅黑");
        r.setFontSize(fontSize);
    }


    public static void setTableStyle(XWPFTable table) {
        CTTblBorders borders = table.getCTTbl().getTblPr().addNewTblBorders();
        CTBorder hBorder = borders.addNewInsideH();
        hBorder.setVal(STBorder.Enum.forString("single"));  // 线条类型
        hBorder.setSz(new BigInteger("1")); // 线条大小
        hBorder.setColor("FFFFFF"); // 设置颜色8

        CTBorder vBorder = borders.addNewInsideV();
        vBorder.setVal(STBorder.Enum.forString("single"));
        vBorder.setSz(new BigInteger("1"));
        vBorder.setColor("FFFFFF");

        CTBorder lBorder = borders.addNewLeft();
        lBorder.setVal(STBorder.NIL);
        lBorder.setSz(new BigInteger("1"));
        lBorder.setColor("3A5FCD");

        CTBorder rBorder = borders.addNewRight();
        rBorder.setVal(STBorder.NIL);
        rBorder.setSz(new BigInteger("1"));
        rBorder.setColor("3A5FCD");

        CTBorder tBorder = borders.addNewTop();
        tBorder.setVal(STBorder.NIL);
        tBorder.setSz(new BigInteger("1"));
        tBorder.setColor("3A5FCD");

        CTBorder bBorder = borders.addNewBottom();
        bBorder.setVal(STBorder.NIL);
        bBorder.setSz(new BigInteger("1"));
        bBorder.setColor("3A5FCD");
    }
}